SQL - ORDER BY

SELECT fname, lname
FROM Students
WHERE rollno >= 1234
ORDER BY lname

SELECT fname, lname
FROM Students
WHERE rollno >= 1234
ORDER BY lname DESC