問題 leetcode.com 解いた SELECT Department, Employee, Salary FROM ( SELECT ( SELECT DISTINCT Salary FROM ( SELECT DENSE_RANK() OVER (ORDER BY Salary DESC) AS 'rank', Salary FROM Employee WHERE Employee.departmentId = DD.id) E WHERE E.rank …

問題 https://leetcode.com/problems/department-highest-salary/ 解いた SELECT EED.name AS 'Department', Employee.name AS 'Employee', Employee.salary AS 'Salary' FROM ( SELECT EE.Max, Department.name FROM ( SELECT MAX(salary) AS Max, departme…

問題 https://leetcode.com/problems/merge-two-sorted-lists/ 解いてみた # Definition for singly-linked list. # class ListNode # attr_accessor :val, :next # def initialize(val = 0, _next = nil) # @val = val # @next = _next # end # end # @para…

問題 https://leetcode.com/problems/consecutive-numbers/ 解いた SELECT L.num AS 'ConsecutiveNums' FROM Logs L, Logs LL, Logs LLL WHERE L.id = LL.id - 1 AND LL.id = LLL.id - 1 AND L.num = LL.num && LL.num = LLL.num GROUP BY L.num; 結果

問題 https://leetcode.com/problems/delete-duplicate-emails/ 解いた DELETE P FROM Person AS P, Person AS PP WHERE P.email = PP.email AND P.ID > PP.id; 結果

問題 https://leetcode.com/problems/rank-scores/ 解いた SELECT score, DENSE_RANK() OVER (ORDER BY score DESC) 'rank' FROM Scores ORDER BY score DESC; 結果

問題 https://leetcode.com/problems/rising-temperature/ 解いた SELECT WWW.id FROM ( SELECT WW.id, W.temperature AS 'pre_temp', WW.temperature AS 'today_temp' FROM Weather AS W, Weather AS WW WHERE DATEDIFF(WW.recordDate, W.recordDate) = 1 O…

問題 https://leetcode.com/problems/median-of-two-sorted-arrays/ 解いた # @param {Integer[]} nums1 # @param {Integer[]} nums2 # @return {Float} def find_median_sorted_arrays(nums1, nums2) nums = (nums1 + nums2).sort result = 0 if nums.lengt…