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.
- Prepare
- SQL
- Basic Select
- Higher Than 75 Marks
- Discussions
Higher Than 75 Marks
Higher Than 75 Marks
Sort by
recency
|
2000 Discussions
|
Please Login in order to post a comment
MYSQL SELECT NAME FROM STUDENTS WHERE MARKS > 75 ORDER BY RIGHT(NAME, 3), ID ASC;
SELECT name FROM students WHERE marks > 75 ORDER BY RIGHT (name, 3) , id ASC ;
SELECT Name FROM STUDENTS WHERE Marks > 75 ORDER BY RIGHT(Name, 3), ID
MSSQL Server
MySQL server -
SELECT NAME FROM STUDENTS WHERE MARKS >75 ORDER BY RIGHT(NAME, 3), -- Orders by the last three characters of the name ID; -- Secondary sort
MS SQL Server
Select name from Students where Marks>75 order by Substring(Name,len(name)-2,3) asc, ID asc