Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 80 of 91

JOINS and SET Operations — Question 16

Back to all questions
16
Question

Question 16

Consider following tables to answer below question :

Salesman (salesman_id, name, city, commission ) and

Customer (customer_id, cust_name, city, grade, salesman_id )

Write an SQL query to display distinct salesman and their cities.

Answer 
SELECT DISTINCT salesman_id, name, city
FROM Salesman;