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
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
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 published on w3resource :
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework