Question

Q 29. Write a query that selects all orders except those with zero or null in the Amt field from table
order.
​

Answer 1

Answer:

SELECT * FROM orders WHERE (amt IS NOT NULL AND amt <> 0);

'<>

means 'not equal to'.