In this lesson, you will learn how to use the
ORDER BY clause to sort retrieved data as needed.
As you learned in the last lesson, the following SQL statement returns a single column from a database table. But look at the output. The data appears to be displayed in no particular order at all.
SELECT prod_nameFROM Products;
prod_name--------------------Fish bean bag toyBird bean bag toyRabbit bean bag toy8 inch teddy bear12 inch teddy bear18 inch teddy bearRaggedy AnnKing doll