Higher Than 75 Marks

Sort by

recency

|

2227 Discussions

|

  • + 0 comments

    oracle -- select name from students where marks>75 order by substr(name,-3,3), id asc;

  • + 0 comments

    what is substr....? does sql have predefined functions...... if sql have predefined functions what are they? and how many of them?

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