w3resource
SQL exercises

SQL Subquery Exercises: Display all the orders that had amounts that were greater than at least one of the orders on September 10th 2012

SQL SUBQUERY: Exercise-23 with Solution

23. Write a query to display all the orders that had amounts that were greater than at least one of the orders from September 10th 2012.

Sample table: Orders


Sample Solution:

SELECT *
FROM Orders
WHERE purch_amt > ANY
   (SELECT purch_amt
	FROM orders
	WHERE  ord_date='2012/09/10');

Sample Output:

ord_no	purch_amt	ord_date	customer_id	salesman_id
70005	2400.60		2012-07-27	3007			5001
70008	5760.00		2012-09-10	3002			5001
70010	1983.43		2012-10-10	3004			5006
70003	2480.40		2012-10-10	3009			5003
70013	3045.60		2012-04-25	3002			5001
70007	948.50		2012-09-10	3005			5002

Practice Online


Inventory database model

Query Visualization:

Duration:

Query visualization of Display all the orders that had amounts that were greater than at least one of the orders on October 9th 2012 - Duration

Rows:

Query visualization of Display all the orders that had amounts that were greater than at least one of the orders on October 9th 2012 - Rows

Cost:

Query visualization of Display all the orders that had amounts that were greater than at least one of the orders on October 9th 2012 - Cost

Contribute your code and comments through Disqus.

Previous: Write a query to display the customers who have a greater gradation than any customer who belongs to the alphabetically lower than the city New York.
Next: Write a query to find all orders with an amount smaller than any amount for a customer in London.

What is the difficulty level of this exercise?



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