Where condition

[varunreddy]

Hi Guys,

I am trying to obtain the results only when a <> 0 and b<>0.

I am trying this:

select * from table where a<> 0 and b<>0.

This is also eliminating the values where a=0 and b has value and when a has value and b is 0.

Scenario:

a=0 and b=0 -- Should not be displayed

a=0 and b=19 -- should display

a=21 and b=0 -- should dispplay

Thanks in advance.

Cheers,

Varun Reddy

[antoniotiman · Accepted solution]

Hi,

try

Where NOT (a=0 and b=0)

Regards,

Antonio

[vinieme12]

You need OR operand

select * from table where a > 0 OR b > 0.

[vishsaggi]

My be try this

Where (A > 0 OR B > 0)

[varunreddy]

Hi All,

Thank you for the quick response.

Cheers,

Varun Reddy