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
|
1935 Discussions
|
Please Login in order to post a comment
SELECT NAME FROM STUDENTS WHERE MARKS >75 ORDER BY RIGHT(NAME, 3) ASC, ID;
By default the ordering is asc so avoided that. Also noted that answers without the ; are also being accepted for MS SQL even though the instructions ask to add ; after the query
Select NAME from STUDENTS where MARKS > 75 ORDER BY RIGHT(NAME, 3), ID
select Name from students where Marks>75 order by Right(name,3),ID;
SELECT NAME FROM STUDENTS WHERE MARKS>75 ORDER BY RIGHT(NAME,3), ID;
select name from students where marks > 75 order by substr(name, length(name) -2) asc, id asc;