I am working with oracle 10g database.
I have a table of with three columns of varchar2 datatype and four columns of number datatype.
In the table there are rows where all the four numeric fields are 0
i.e looking at a row of record, the value of the four numeric fields is 0.
I want to extract out or view only rows with at least one of the four numeric fields not equal to zero. I dont want to view the records having the four numeric fields all equal to zero.
Please can some one help me out with regards to the right SQL query to be used
Thanks but this query does not seem to solve the problem
the Or clause will select rows where at least one numeric value field has a zero. I am interested in excluding rows where all the four numeric fields each have 0 (zero) stored as the database value i.e
field1 field2 field3 field4
0 0 0 0
0 0 7 0.
I am interested in excluding row1 and not row2
I think this should work fine.
I tried it earlier before contacting the forum but was not sure cos i'm dealing
with rows of about 1million records and there is no way i can manually check.
I just hope it works fine.
Thanks guys, you are doing great at the forum.