programming-examples/22. Write a query to display the customers who have a greater gradation than any customer who belongs to the alphabetically lower than the city 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.

8 lines

282 B

SQL

Raw Permalink Blame History

 /*22. Write a query to display the customers who have a greater gradation than any customer who belongs to the alphabetically
 lower than the city New York.*/
 SELECT *
 FROM customer
 WHERE grade > ANY
    (SELECT grade
     FROM CUSTOMER
     WHERE  city < 'New York');