﻿ SQL SUBQUERIES: Display all the orders that had amounts that were greater than at least one of the orders on September 10th 2012 - w3resource

# 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');
``````

Output of the Query:

```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
```

Explanation:

## Query Visualization:

Duration:

Rows:

Cost:

Contribute your code and comments through Disqus.

What is the difficulty level of this exercise?

﻿