摘要: 第N高的薪水 - LeetCode (中国) https://leetcode-cn.com/problems/nth-highest-salary/description/ Write a SQL query to get the nth highest salary from the Emplo 阅读全文
posted @ 2018-05-25 21:07 papering 阅读(218) 评论(0) 推荐(0) 编辑
摘要: select case when if 的一些用法 - 马丁传奇 - 博客园 https://www.cnblogs.com/martinzhang/p/3220595.html Write a SQL query to get the second highest salary from the  阅读全文
posted @ 2018-05-25 19:47 papering 阅读(241) 评论(0) 推荐(0) 编辑
摘要: https://leetcode-cn.com/problems/employees-earning-more-than-their-managers/description/ The Employee table holds all employees including their manage 阅读全文
posted @ 2018-05-25 02:17 papering 阅读(231) 评论(0) 推荐(0) 编辑
摘要: 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 阅读全文
posted @ 2018-05-25 02:11 papering 阅读(241) 评论(0) 推荐(0) 编辑
摘要: SELECT * FROM cinema WHERE description NOT IN ("boring") AND id MOD 2 = 1 ORDER BY rating DESC 阅读全文
posted @ 2018-05-25 01:59 papering 阅读(192) 评论(0) 推荐(0) 编辑
摘要: 无重复字符的最长子串 - LeetCode (中国) https://leetcode-cn.com/problems/longest-substring-without-repeating-characters/description/ 阅读全文
posted @ 2018-05-25 00:29 papering 阅读(169) 评论(0) 推荐(0) 编辑