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
|
2038 Discussions
|
Please Login in order to post a comment
select name from students
where marks > 75 order by right(name, 3), id;
SELECT S.NAME FROM STUDENTS S WHERE S.MARKS > 75 ORDER BY RIGHT(S.NAME, 3), S.ID ASC
select name from students where marks>75 order by substr(name,length(name)-2,length(name)) ,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) ASC, ID ASC