SELECT expressions FROM tables [WHERE conditions] [ORDER BY expression [ ASC | DESC ]] LIMIT row_count;
SELECT student_id, student_name, student_address FROM Students WHERE student_id <= 7 ORDER BY student_id DESC LIMIT 4;
SELECT student_id, student_name, student_address FROM Students WHERE student_id <= 7 ORDER BY student_id ASC LIMIT 4;