programming-examples/29. Write a query to find all those customers whose grade are not as the grade, belongs to the city Paris.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

229 B

SQL

Raw Permalink Blame History

 /*29. Write a query to find all those customers whose grade are not as the grade, belongs to the city Paris.*/
 SELECT *
 FROM customer
 WHERE grade NOT IN
    (SELECT grade
     FROM customer
     WHERE city='Paris');