sql - To display all records of table? -

to display records of table1 except containing 2 b containing 5

table1 ------           b -          8          5  2          9  null       4  2          5

select * table1 not in 2 , b not in 5;

it doesn't work ,it display 0 rows selected

try this:

select * table1 (a null or != 2) , (b null or b != 5)

edit

sql fiddle, many nagaraj s

And