Into Statement  «Prev  Next»

Use SQL ORDER BY Clause - Exercise

Objective:
Given certain specifications, create a SELECT statement that correctly sorts the information in a table. Create a SELECT statement for the following table, named Orders:
OrderNum ItemNum Date Qty CustID
4332 1001 12/31/97 5 0001
4321 1001 01/10/98 1 1231
4332 1002 12/31/97 1 0001
4333 1003 01/15/98 1 0002
4321 1010 01/10/98 10 1231
4334 1011 01/10/98 1 1231
4335 1231 01/15/98 1 4325
4335 1001 01/15/98 1 4325