Higher Than 75 Marks

  • + 0 comments

    PL/SQL, MySQL, SQL

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

    --RIGHT() https://stackoverflow.com/questions/17409605/how-can-i-use-left-right-functions-in-sql-to-get-last-3-characters