Higher Than 75 Marks

  • + 64 comments

    For MS SQL Server, you can use RIGHT function like;

    SELECT NAME FROM STUDENTS WHERE MARKS > 75 ORDER BY RIGHT(NAME, 3), ID ASC;