programming-examples/26. Write a query to display only those customers whose grade are, in fact, higher than every customer in New York.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.

7 lines

239 B

SQL

Raw Permalink Blame History

 /*26. Write a query to display only those customers whose grade are, in fact, higher than every customer in New York.*/
 SELECT *
 FROM customer
 WHERE grade > ALL
    (SELECT grade
     FROM customer
     WHERE city='New York');