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
|
2283 Discussions
|
Please Login in order to post a comment
SELECT DISTINCT NAME FROM ( SELECT DISTINCT NAME, ID FROM STUDENTS WHERE (MARKS>75) ORDER BY RIGHT(NAME,3) ASC, ID ASC)A
SELECT Name from STUDENTS WHERE Marks>75 Order by RIGHT(Name,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),ID;
SELECT NAME
FROM STUDENTS
WHERE MARKS > 75
ORDER BY RIGHT(NAME, 3), ID;