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--------------.5 ton anvil1 ton anvil2 ton anvilDetonatorBird seedCarrotsFusesJetPack 1000JetPack 2000