전체 글

https://leetcode.com/problems/delete-duplicate-emails/ Delete 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 delete a from Person a, Person b where a.id > b.id and a.email = b.email; best DELETE FROM Person WHERE Id NOT IN (SELECT * FROM( SELECT MIN(Id) FROM Per..

https://leetcode.com/problems/swap-salary/ Swap 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 update Salary set sex = if (sex = 'm', 'f', 'm'); best UPDATE Salary SET sex = (CASE WHEN sex = 'm' THEN 'f' ELSE 'm' END);

https://leetcode.com/problems/calculate-special-bonus/ Calculate Special Bonus - 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 # Write your MySQL query statement below select employee_id, if (employee_id%2 = 1 and name not like 'M%', salary, 0) as bonus from Employees

https://leetcode.com/problems/n-th-tribonacci-number/ N-th Tribonacci Number - 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 class Solution { public: int tribonacci(int n) { int T[n+1]; T[0] = 0; if (n == 0) return T[0]; T[1] = 1; if (n == 1) return T[1]; T[2] = 1; for(int i = 3; i

https://leetcode.com/problems/fibonacci-number/ dynamic programming day 1 Fibonacci Number - 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 class Solution { public: int fib(int n) { if (n < 2) return n; return fib(n - 1) + fib(n - 2); } }; class Solution { public: int fib(int n) {..

없음. 줄여쓰는 것임. 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 select name as Customers from Customers as a left outer join Orders as b on a.id = b.customerId where b.id is null select c.name as Cust..

https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html#operator_equal-to MySQL :: MySQL 8.0 Reference Manual :: 12.4.2 Comparison Functions and Operators 12.4.2 Comparison Functions and Operators Table 12.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator , != Not equal operator

https://leetcode.com/problems/find-customer-referee/ Find Customer Referee - 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 != 서로 같은 뜻으로 같지 않다를 나타내며 성능 차이는 없다. 다만, 문제에서도 알 수 있듯이 NULL은 처리가 되지 않기 때문에 따로 처리해줘야 한다. Reference https://dev.mysql.com/doc/refman/8.0/en/comparison-operators..