w3resource
SQL exercises

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

Explanation:

Syntax of display all customers, who are either belongs to the city New York or had a grade above 100

Pictorial presentation:

Result of display all customers, who are either belongs to the city New York or had a grade above 100

Query Visualization:

Duration:

Query visualization of Display all information using OR operator with specified conditions - Duration

Rows:

Query visualization of Display all information using OR operator with specified conditions - Rows

Cost:

Query visualization of Display all information using OR operator with specified conditions - Cost

 

Practice Online


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?



New Content: Composer: Dependency manager for PHP, R Programming