목록Oracle (6)
복's
[ LeetCode - 182 ] Duplicate Emails
https://leetcode.com/problems/duplicate-emails/description/ Duplicate Emails - LeetCode Can you solve this real interview question? Duplicate Emails - Table: Person +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | email | varchar | +-------------+---------+ id is the primary key (column with unique val leetcode.com 중복되는 email 컬럼이 있는 경우만 출력하면 되는 문제로 2가지의 풀..
[ LeetCode - 180 ] Consecutive Numbers
https://leetcode.com/problems/consecutive-numbers/ Consecutive Numbers - LeetCode Can you solve this real interview question? Consecutive Numbers - Table: Logs +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | num | varchar | +-------------+---------+ In SQL, id is the primary key for this table. leetcode.com LAG, LEAD 함수를 통해서 이전 row의 값과 다음 row의 값을 가져와서 문제..
[ LeetCode - 178 ] Rank Scores
https://leetcode.com/problems/rank-scores/description/ Rank Scores - LeetCode Can you solve this real interview question? Rank Scores - Table: Scores +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | score | decimal | +-------------+---------+ id is the primary key (column with unique values) leetcode.com 음... 진짜 rank 함수만 쓰면 바로 넘어갈 수 있는 문제였다. 습관적으로 맨 처음에는 ..
[ LeetCode - 176 ] Second Highest Salary
https://leetcode.com/problems/second-highest-salary/description/ Second Highest Salary - LeetCode Can you solve this real interview question? Second Highest Salary - Table: Employee +-------------+------+ | Column Name | Type | +-------------+------+ | id | int | | salary | int | +-------------+------+ id is the primary key (column with unique values) leetcode.com DB는 Medium 까지는 풀어도되지 않을까 싶어서 풀어..
[ LeetCode - 181 ] Employees Earning More Than Their Managers
https://leetcode.com/problems/employees-earning-more-than-their-managers/description/ Employees Earning More Than Their Managers - LeetCode Can you solve this real interview question? Employees Earning More Than Their Managers - Table: Employee +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | | salary | int | | managerId | int | +------ l..
[ LeetCode - 175 ] Combine Two Tables
https://leetcode.com/problems/combine-two-tables/description/ Combine Two Tables - LeetCode Can you solve this real interview question? Combine Two Tables - Table: Person +-------------+---------+ | Column Name | Type | +-------------+---------+ | personId | int | | lastName | varchar | | firstName | varchar | +-------------+---------+ personId i leetcode.com LeetCode에 SQL 문제도 있었다 !!! 진짜 오랜만에 쿼리..