You are viewing a single comment's thread. Return to all comments →
you don't need to use length function. Just write select name from STUDENTS where marks>75 order by substr(name,-3,3), id;
When you pass a negative number in the substr method as the starting index, it starts the count from the end of the string.
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 →
you don't need to use length function. Just write select name from STUDENTS where marks>75 order by substr(name,-3,3), id;
When you pass a negative number in the substr method as the starting index, it starts the count from the end of the string.