select where column value != "0"

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

0

11y ago

yes numeric value should not be written in ""

you should try this:

select from profit where performance <>0

0

select * from profit where performance != "0"

0

Hello,

Use below script-

SELECT * FROM dbo.profit WITH(NOLOCK) WHERE performance != '0'

0

select * from profit where performance != "0"

0

Hi if you want to select value but you need nor zero use below query.

select from profit where performance <> 0

-1