[프로그래머스] SUM, MAX, MIN > 최솟값 구하기

-- MySQL SELECT DATETIME from animal_ins order by datetime asc limit 1; -- Oracle SELECT A.DATETIME AS "시간" FROM (SELECT DATETIME FROM ANIMAL_INS ORDER BY DATETIME ASC ) A WHERE ROWNUM
Problem Solution/Programmers 2022. 10. 6. 01:55
[프로그래머스] SUM, MAX, MIN > 동물 수 구하기

-- MySQL SELECT count(*) from animal_ins; -- Oracle SELECT COUNT(*) AS count FROM ANIMAL_INS;
Problem Solution/Programmers 2022. 10. 6. 01:54
[프로그래머스] SUM, MAX, MIN > 중복 제거하기

-- MySQL select count(DISTINCT NAME) from ANIMAL_INS where NAME IS NOT NULL -- Oracle SELECT COUNT(DISTINCT NAME) AS "count" FROM ANIMAL_INS WHERE NAME IS NOT NULL;
Problem Solution/Programmers 2022. 10. 6. 01:54
[프로그래머스] SUM, MAX, MIN > 최댓값 구하기

-- MySQL SELECT DATETIME FROM animal_ins order by datetime desc limit 1; -- Oracle SELECT A.DATETIME AS "시간" FROM (SELECT DATETIME FROM ANIMAL_INS ORDER BY DATETIME DESC ) A WHERE ROWNUM
Problem Solution/Programmers 2022. 10. 6. 01:53
1 ··· 9 10 11 12 13 14 15 ··· 21
공지사항
최근에 올라온 글
최근에 달린 댓글
Total
Today
Yesterday
링크
TAG more
«   2025/09   »
일 월 화 수 목 금 토
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30
글 보관함