====== SQL - ORDER BY ======

===== Sort the returned records =====

<code sql>
SELECT fname, lname
FROM Students
WHERE rollno >= 1234
ORDER BY lname
</code>

----

===== Order in descending order =====


<code sql>
SELECT fname, lname
FROM Students
WHERE rollno >= 1234
ORDER BY lname DESC
</code>

----