programming-examples/28.Write a query to get all the information for those customers whose grade is not as the grade of customer who belongs to the city London.sql at master - programming-examples - michuIT: Everything is code

You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

8 lines

265 B

SQL

Raw Permalink Blame History

 /*28.Write a query to get all the information for those customers whose grade is not as the grade of customer who belongs to
 the city London.*/
 SELECT *
 FROM customer
 WHERE grade <> ALL
    (SELECT grade
     FROM customer
     WHERE city='London');