programming-examples/21. Write a query to display the salesmen which name are alphabetically lower than the name of the customers.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

235 B

SQL

Raw Permalink Blame History

 /*21. Write a query to display the salesmen which name are alphabetically lower than the name of the customers.*/
 SELECT *
 FROM salesman a
 WHERE EXISTS
    (SELECT *
     FROM CUSTOMER b
     WHERE  a.name  < b.cust_name);