SQL: Filter records using where clause and or operator
SQL Wildcard & Special Operator : Exercise-1 with Solution
Write a SQL statement to find those salesmen with all information who come from the city either Paris or Rome.
Sample table: salesman
SELECT * FROM salesman WHERE city = 'Paris' OR city = 'Rome';
Output of the Query:
salesman_id name city commission 5002 Nail Knite Paris 0.13 5006 Mc Lyon Paris 0.14 5007 Paul Adam Rome 0.13
Pictorial presentation :
Contribute your code and comments through Disqus.
What is the difficulty level of this exercise?