You are viewing a single comment's thread. Return to all comments →
Use this it works SELECT (NAME) FROM STUDENTS WHERE MARKS>75 ORDER BY SUBSTR(NAME,-3,3), ID ASC;
-3 depicts last three characters whereas 3 depicts length
Seems like cookies are disabled on this browser, please enable them to open this website
Higher Than 75 Marks
You are viewing a single comment's thread. Return to all comments →
Use this it works SELECT (NAME) FROM STUDENTS WHERE MARKS>75 ORDER BY SUBSTR(NAME,-3,3), ID ASC;
-3 depicts last three characters whereas 3 depicts length