|
||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread |
| SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it. |
|
||||||
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread |
05-23-2006, 11:37 PM
|
|||
|
|||
SQL 92 dialect question:
List from particular customers with minum orders?Ascending list of wine name, wine year and ordered quantity for all ordered wines by customers located in Paris and who ordered more than 100 bottles
    
|
|
05-23-2006, 11:57 PM
|
|||
|
|||
SQL 92 answer.
Re: List from particular customers with minum orders?
SELECT w.name, w.year, Sum(o.qty)
|
|
| Thread Tools | Search this Thread |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| List all customers from table customers that haven't made any order during year 2005? | alexfr | SQL - Questions and Answers | 1 | 05-24-2006 12:04 AM |
| List by ascending number of orders the customers that have placed more than 1 order? | alexfr | SQL - Questions and Answers | 1 | 05-24-2006 12:03 AM |
| List all customers who ordered products where price of the item is $100 greater than average order? | alexfr | SQL - Questions and Answers | 1 | 05-24-2006 12:02 AM |
| List all customers whose name is present more than once in the table? | alexfr | SQL - Questions and Answers | 1 | 05-24-2006 12:01 AM |
| list customers with average ordered quantities? | alexfr | SQL - Questions and Answers | 1 | 05-23-2006 11:56 PM |
