SQL: Select specified columns with where clause
SQL Basic Select Statement : Exercise-9 with Solution.
Write a query to display names and city of salesman, who belongs to the city of Paris.
Sample table: salesman
Sample Solution :
SELECT name,city FROM salesman WHERE city='Paris';
Output of the Query:
name city Nail Knite Paris Mc Lyon Paris
Pictorial presentation :
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a query which will retrieve the values of salesman id of all salesmen getting orders from the customers in orders table without any repeats.
Next: Write a SQL statement to display all the information for those customers with a grade of 200.
What is the difficulty level of this exercise?