국내주식 / 일본주식 / 개발자이야기

작성 코드

select t1.ID, t2.FISH_NAME as FISH_NAME, t1.LENGTH
from FISH_INFO t1 inner join
     FISH_NAME_INFO t2 on t1.FISH_TYPE = t2.FISH_TYPE
     where t1.FISH_TYPE IN (select FISH_TYPE
                           from FISH_INFO
                           group by FISH_TYPE
                           having LENGTH = MAX(LENGTH))
     order by t1.ID

작성 코드

select ID, LENGTH
from FISH_INFO
where LENGTH is not null
order by 2 desc, 1 asc
limit 10