Higher Than 75 Marks

Sort by

recency

|

2230 Discussions

|

  • + 0 comments

    oracle:

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

  • + 0 comments

    My SQL

    select name from students where marks > 75 order by substr(name,-3), id;
    
  • + 0 comments

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

  • + 0 comments

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

  • + 1 comment

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