Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 16 of 78

Simple Queries in SQL — Question 9

Back to all questions
9
Question

Question 9

Write a query that selects all orders (Order table) except those with zeros or NULLs in the amt field.

Answer 
SELECT *
FROM order
WHERE amt IS NOT NULL AND amt <> 0 ;