SQL Subquery Exercises: Find the salesmen who have multiple customers

SQL SUBQUERY: Exercise-16 with Solution

16. From the following tables write a SQL query to find salespeople who deal with multiple customers. Return salesman_id, name, city and commission.

Sample table: Customer

Sample table: Salesman

Sample Solution:

SELECT * 
FROM salesman 
WHERE salesman_id IN (
   SELECT DISTINCT salesman_id 
   FROM customer a 
   WHERE EXISTS (
      SELECT * 
      FROM customer b 
      WHERE b.salesman_id=a.salesman_id 
      AND b.cust_name<>a.cust_name));

Output of the Query:

salesman_id	name		city	commission
5001		James Hoog	New York	0.15
5002		Nail Knite	Paris		0.13

Explanation:

Practice Online

Query Visualization:

Duration:

Rows:

Cost:

Contribute your code and comments through Disqus.

Previous: Write a query to extract the data from the customer table if and only if one or more of the customers in the customer table are located in London.
Next: From the following tables, write a SQL query to find the salespeople who deal a single customer. Return salesman_id, name, city and commission.