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

|

2343 Discussions

|

  • almazahy921
     + 0 comments

    SET NOCOUNT ON;

    select   name

    from    STUDENTS

    where    marks > 75

    order by

       RIGHT(name,3),ID; go

  • ashwinpahade97
     + 0 comments

    SELECT name FROM students WHERE marks > 75 ORDER BY RIGHT(name, 3), id;

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