SQLConfiguration SQLConfiguration


Basic Queries  «Prev  Next»

Order By Clause -Exercise

Using ORDER BY - Exercise

Objective: Sort table rows using the ORDER BY clause.

Exercise scoring

This exercise is worth 3 points and is automatically scored. When you are finished, just click the Submit button to receive full credit.

Background/overview


Write a SELECT statement that sorts the CustTable in ascending order by state and by last name.

Download files

You will need the file sqlfun.asp to do this exercise.

Instructions

Open the sqlfun.asp file in the source code editor
Locate the line: querystring = " ",
Insert the complete SELECT statement between the quotation marks.