목록Max (2)

rose_brown

[프로그래머스] SQL - 물고기 종류 별 대어 찾기

1. 문제https://school.programmers.co.kr/learn/courses/30/lessons/293261 2. 코드실패 코드SELECT i.ID, n.FISH_NAME, MAX(i.LENGTH) AS LENGTHFROM FISH_INFO iJOIN FISH_NAME_INFO n ON i.FISH_TYPE = n.FISH_TYPEWHERE i.LENGTH >= 10GROUP BY i.ID, n.FISH_NAMEORDER BY i.ID;성공 코드SELECT i.ID, n.FISH_NAME, i.LENGTHFROM FISH_INFO iJOIN FISH_NAME_INFO n ON i.FISH_TYPE = n.FISH_TYPEJOIN ( SELECT FISH_TYPE, MAX(LENGTH..
코딩/프로그래머스 2024. 10. 15. 18:34
[프로그래머스] SQL - 조회수가 가장 많은 중고거래 게시판의 첨부파일 조회하기

1. 문제https://school.programmers.co.kr/learn/courses/30/lessons/1646712. 코드SELECT CONCAT("/home/grep/src/",b.BOARD_ID,"/",f.FILE_ID,f.FILE_NAME,f.FILE_EXT) AS FILE_PATHFROM USED_GOODS_BOARD bJOIN USED_GOODS_FILE f USING(BOARD_ID)WHERE VIEWS = (SELECT MAX(VIEWS) FROM USED_GOODS_BOARD)ORDER BY b.VIEWS DESC, f.FILE_ID DESC;3. 다른 코드SELECT CONCAT('/home/grep/src/', BOARD_ID, '/', FILE_ID, FILE_NAME, F..
코딩/프로그래머스 2024. 10. 9. 18:05
이전 Prev 1 Next 다음