Into Statement  «Prev  Next»

Use the 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