[SQL문제풀기] Higher Than 75 Marks

문제

Higher Than 75 Marks | HackerRank

Query the names of students scoring higher than 75 Marks. Sort the output by the LAST three characters of each name.

https://www.hackerrank.com/challenges/more-than-75-marks/problem?isFullScreen=true

MySQL

내가 작성한 정답1 - substring, substr

select name
from students
where marks > 75
order by substring(name,-3,3), id;
    
select name
from students
where marks > 75
order by substr(name,-3,3), id;

내가 작성한 정답2 - right

select name
from students
where marks > 75
order by right(name,3), id;

Oracle

내가 작성한 정답 - substr

select name
from students
where marks > 75
order by substr(name,-3,3), id;

MS SQL Server

내가 작성한 정답 - right

select name
from students
where marks > 75
order by right(name,3), id;

DB2

내가 작성한 정답 - substr, length

select name
from students
where marks > 75
order by substr(name,length(name)-2,3), id;

정리!