select where column value != 0

Question

hi there I have an access database profit and a column performance with negative positive and zero values. i am trying to select from my table as below. select from profit where performance != 0 and select from profit where performance > but am getting errors I want select only where values are greater or less than 0 any help will be appreciated

Manoj Bhoir · Answer

Hi If datatype of performance columns is string then try this : select from profit where performance '0' if it is integer or numeric then use this : select from profit where performance 0

Palak Parmar · Answer

yes numeric value should not be written in  you should try this: select from profit where performance 0

Rahul Prajapat · Answer

select * from profit where performance != 0

Upendra Pratap Shahi · Answer

Hello Use below script- SELECT * FROM dbo . profit WITH ( NOLOCK ) WHERE performance != '0'

Vignesh Mani · Answer

select * from profit where performance != 0

Vignesh Mani · Answer

Hi if you want to select value but you need nor zero use below query. select from profit where performance 0

select where column value != "0"