SQL: Display all information using OR operator with specified conditions
SQL Boolean Operator Statement : Exercise-3 with Solution.
Write a SQL statement to display all customers, who are either belongs to the city New York or had a grade above 100.
Sample table: customer
Sample Solution :
SELECT * FROM customer WHERE city = 'New York' OR grade>100;
Output of the Query:
customer_id cust_name city grade salesman_id 3002 Nick Rimando New York 100 5001 3007 Brad Davis New York 200 5001 3005 Graham Zusi California 200 5002 3008 Julian Green London 300 5002 3004 Fabian Johnson Paris 300 5006 3003 Jozy Altidor Moscow 200 5007
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a query statement to display all customers in New York who have a grade value above 100.
Next: Write a SQL statement to display all the customers, who are either belongs to the city New York or not had a grade above 100.
What is the difficulty level of this exercise?