摘要:
第N高的薪水 - LeetCode (中国) https://leetcode-cn.com/problems/nth-highest-salary/description/ Write a SQL query to get the nth highest salary from the Emplo 阅读全文
摘要:
select case when if 的一些用法 - 马丁传奇 - 博客园 https://www.cnblogs.com/martinzhang/p/3220595.html Write a SQL query to get the second highest salary from the 阅读全文
摘要:
https://leetcode-cn.com/problems/employees-earning-more-than-their-managers/description/ The Employee table holds all employees including their manage 阅读全文
摘要:
https://leetcode-cn.com/problems/swap-salary/description/ Given a table salary, such as the one below, that has m=male and f=female values. Swap all f 阅读全文
摘要:
SELECT * FROM cinema WHERE description NOT IN ("boring") AND id MOD 2 = 1 ORDER BY rating DESC 阅读全文
摘要:
无重复字符的最长子串 - LeetCode (中国) https://leetcode-cn.com/problems/longest-substring-without-repeating-characters/description/ 阅读全文