CODE EXAMPLE FOR SQL

mysql order specific records at the top

SELECT id, name, grade
FROM Students
ORDER BY FIELD(grade, "A") DESC, name ASC;