목록SQL/SQL 문제풀이 (18)

웅겹살의 프로그래밍 삼매경

[SQL] 프로그래머스 오랜 기간 보호한 동물(1)

https://programmers.co.kr/learn/courses/30/lessons/59044 코딩테스트 연습 - 오랜 기간 보호한 동물(1) ANIMAL_INS 테이블은 동물 보호소에 들어온 동물의 정보를 담은 테이블입니다. ANIMAL_INS 테이블 구조는 다음과 같으며, ANIMAL_ID, ANIMAL_TYPE, DATETIME, INTAKE_CONDITION, NAME, SEX_UPON_INTAKE는 각각 동물의 아이디 programmers.co.kr mySql SELECT I.NAME, I.DATETIME FROM ANIMAL_INS AS I LEFT JOIN ANIMAL_OUTS AS O ON I.ANIMAL_ID = O.ANIMAL_ID WHERE I.ANIMAL_ID NOT IN (..
SQL/SQL 문제풀이 2022. 3. 25. 22:55
[SQL] LeetCode SQL 178. Rank Scores (DENSE_RANK)

https://leetcode.com/problems/rank-scores/ Rank Scores - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com -- MYSQL SELECT score , DENSE_RANK() OVER (ORDER BY score DESC ) 'rank' FROM Scores; -- ORACLE SELECT score , DENSE_RANK() OVER (ORDER BY score DESC ) as rank FROM Scores;
SQL/SQL 문제풀이 2021. 12. 19. 22:35
[SQL] LeetCode SQL 184. Department Highest Salary

https://leetcode.com/problems/department-highest-salary/ Department Highest Salary - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com 부서별 salary가 가장높은 친구들 뽑기
SQL/SQL 문제풀이 2021. 12. 1. 14:25
[SQL] LeetCode SQL 177. Nth Highest Salary

https://leetcode.com/problems/nth-highest-salary/ Nth Highest Salary - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com 함수(Function) 문제가 나타났다 Mysql Oracle
SQL/SQL 문제풀이 2021. 11. 30. 23:57
[SQL] LeetCode SQL 176. Second Highest Salary

https://leetcode.com/problems/second-highest-salary/ Second Highest Salary - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com salary가 2번째로 높은친구 뽑기 예외조건은 row가 1개일경우 null 출력 MYSQL Oracle
SQL/SQL 문제풀이 2021. 11. 29. 22:02
[SQL] LeetCode SQL 197. Rising Temperature

https://leetcode.com/problems/rising-temperature/ Rising Temperature - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com 어제보다 온도가 높은 id출력 Oracle Mysql
SQL/SQL 문제풀이 2021. 11. 29. 01:33
[SQL] LeetCode SQL 1179. Reformat Department Table

https://leetcode.com/problems/reformat-department-table/ Reformat Department Table - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com 각 부서의 월별 수익현황 출력 1-3월만 존재 4-12월 내역은 null 더 좋은방법이 있는지는 추후에 찾아보는걸로..
SQL/SQL 문제풀이 2021. 11. 29. 01:10
[SQL] LeetCode SQL 183. Customers Who Never Order

https://leetcode.com/problems/customers-who-never-order/ Customers Who Never Order - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com 주문안한 고객 찾아내기 not exists를 이용하며 풀이했다 심플!
SQL/SQL 문제풀이 2021. 11. 29. 00:24
[SQL] LeetCode SQL 182. Duplicate Emails

https://leetcode.com/problems/duplicate-emails/ Duplicate Emails - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com LeetCode SQL문제풀이 시작 문제는 심플하다 중복된 이메일이 1개 초과인 이메일을 뽑아내면된다. select email from Person group by email having count(email) > 1 심플!!
SQL/SQL 문제풀이 2021. 11. 29. 00:13
[SQL] 고양이와 개는 몇 마리 있을까

https://programmers.co.kr/learn/courses/30/lessons/59040 코딩테스트 연습 - 고양이와 개는 몇 마리 있을까 ANIMAL_INS 테이블은 동물 보호소에 들어온 동물의 정보를 담은 테이블입니다. ANIMAL_INS 테이블 구조는 다음과 같으며, ANIMAL_ID, ANIMAL_TYPE, DATETIME, INTAKE_CONDITION, NAME, SEX_UPON_INTAKE는 각각 동물의 아이디 programmers.co.kr -- 코드를 입력하세요 SELECT ANIMAL_TYPE, COUNT(ANIMAL_TYPE) count FROM ANIMAL_INS WHERE ANIMAL_TYPE IN ('Cat', 'Dog') GROUP BY ANIMAL_TYPE ORD..
SQL/SQL 문제풀이 2021. 7. 6. 00:29
Prev 1 2 Next