Bright Tutorials

CBSE Class 12 Computer Science Question 7 of 20

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 ;

Get the Bright Tutorials app Stuck on a question? Ask Bright Buddy — your AI tutor — for step-by-step help in the app. Get it →