programming-examples/11. Write a query to find the name and numbers of all salesmen who had more than one customer.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.

6 lines

148 B

SQL

Raw Permalink Blame History

 SELECT salesman_id,name
 FROM salesman a
 WHERE 1 <
     (SELECT COUNT(*)
      FROM customer
      WHERE salesman_id=a.salesman_id);