Higher Than 75 Marks

Sort by

recency

|

2225 Discussions

|

  • + 0 comments

    SQL SERVER

    select name from students where marks > 75 order by RIGHT(NAME,3), id asc

  • + 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

  • + 0 comments

    MySQL:

    SELECT NAME FROM STUDENTS WHERE 1=1 AND MARKS>75 ORDER SUBSTR(NAME,-3),ID ASC;

  • + 0 comments

    select name from students where marks >75 order by right(name,3) asc, id

  • + 0 comments

    MY SQL

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