Computer Science

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

SQL Queries

6 Likes

Answer

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

Answered By

3 Likes

Related Questions

Write a query to display the name of employee whose name contains 'M' as first alphabet 'L' as third alphabet.
View Answer Bookmark Now

Write a query on the customers table whose output will exclude all customers with a rating <= 100, unless they are located in Shimla.
View Answer Bookmark Now

Write SQL commands for the following on the basis of given table STUDENT :
Table : STUDENT
StudentNo. Class Name GAME Grade1 SUPW Grade2
10 7 Sameer Cricket B Photography A
11 8 Sujit Tennis A Gardening C
12 7 Kamal Swimming B Photography B
13 7 Veena Tennis C Cooking A
14 9 Archana Basket Ball A Literature A
15 10 Arpit Cricket A Gardening C
Display the names of the students who are getting a grade 'C' in either GAME or SUPW.
Display the different games offered in the school.
Display the SUPW taken up by the students, whose name starts with 'A'.

View Answer Bookmark Now

Write SQL commands for the following on the basis of given table SPORTS :
Table : SPORTS
StudentNo. Class Name Game1 Grade1 Game2 Grade2
10 7 Sameer Cricket B Swimming A
11 8 Sujit Tennis A Skating C
12 7 Kamal Swimming B Football B
13 7 Venna Tennis C Tennis A
14 9 Archana Basketball A Cricket A
15 10 Arpit Cricket A Athletics C
Display the names of the students who have grade 'C' in either Game1 or Game2 or both.
Display the names of the students who have same game for both Game1 and Game2.
Display the games taken up by the students, whose name starts with 'A'.
View Answer Bookmark Now