[MYSQL] 가장 큰 물고기 10마리 구하기

https://school.programmers.co.kr/learn/courses/30/lessons/298517

프로그래머스

 

정답

SELECT ID, LENGTH 
FROM FISH_INFO 
ORDER BY IFNULL(LENGTH,10) DESC, ID
LIMIT 10
;

 

IFNULL

https://lavender1122.tistory.com/249

[MySQL & ORLACLE] IFNULL

LIMIT

https://lavender1122.tistory.com/250

[MySQL] LIMIT와 Offset 사용법