We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Basic Select
  4. Higher Than 75 Marks
  5. Discussions

Higher Than 75 Marks

Sort by

recency

|

2341 Discussions

|

  • srihariachukatl1
     + 0 comments

    For MySQL this code works

    SELECT Name
FROM Students
WHERE Marks > 75
ORDER BY SUBSTR(Name, -3) ASC, ID ASC;

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

  • towhidulislamni1
     + 0 comments

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

  • ashleytyq
     + 0 comments

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

  • shreyashvaidya8
     + 0 comments

    ORDER BY RIGHT(name, 3), id;