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
|
2319 Discussions
|
Please Login in order to post a comment
SELECT NAME FROM STUDENTS WHERE MARKS > 75 ORDER BY RIGHT(NAME,3), ID ASC;
select name from students where marks > 75 order by substr(name, -3),id
Higher Than 75 Marks - SOLUTION
select name from students where marks > 75 order by upper(right(name,3)) , id
MS SQL
select Name from STUDENTS s WHERE Marks > 75 Order by RIGHT(Name,3),ID