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

|

2332 Discussions

|

  • samuel2ayman
     + 0 comments
    SELECT NAME FROM STUDENTS 
WHERE MARKS > 75
ORDER BY SUBSTR(NAME,-3,3) ASC , ID

  • yousif_yehia13
     + 0 comments

    /Oracle Code/ select name from students where marks >75 order by substr(name,-3) , ID ASC;

  • joelforson62
     + 0 comments

    In MySQL:

    select name from students where Marks > 75 order by SUBSTRING(name, -3), ID ASC;

  • veeraganti_sush1
     + 0 comments

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

  • pvj_fagotista
     + 0 comments
    SELECT
    Name
FROM 
    STUDENTS
WHERE
    Marks > 75
ORDER BY 
    RIGHT(Name, 3),
    ID ASC