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
|
2309 Discussions
|
Please Login in order to post a comment
select id,name from students where marks > 75 order by substr(name, LENGTH(name) - 2, 3) asc,id asc; this is not working tough output is coming
SELECT Name FROM STUDENTS WHERE Marks > 75 ORDER BY RIGHT(Name, 3), ID;
select name from students where marks >75 order by substr(name,-3,3) asc, id asc
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 ;