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

|

2151 Discussions

|

  • pansarevishal561
     + 0 comments

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

    at last id ASC we wirte used to In case there are multiple students with the same last three characters in their names

  • vinayprasad741
     + 0 comments

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

    make sure to select my sql server

  • danielemad95
     + 1 comment

    SELECT Name,marks,ID FROM STUDENTS WHERE Marks > 75 ORDER BY RIGHT(Name,3), ID asc ; whats wrong with this query

  • hoaxer_prelude_1
     + 0 comments

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

  • aniketpawar5666
     + 0 comments

    to honest 'discussions' section should be renamed as answers section we come here to get a hint like what concept to use and not to see answers