![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL
flyatcmu
这个作者很懒,什么都没留下…
展开
-
Nth Highest Salary
Write a SQL query to get thenthhighest salary from theEmployeetable. +----+--------+ | Id | Salary | +----+--------+ | 1 | 100 | | 2 | 200 | | 3 | 300 | +----+--------+ For example, given the above Employee table, thenthhighest salary...原创 2020-06-20 06:52:46 · 187 阅读 · 0 评论 -
Reported Posts II
Table:Actions +---------------+---------+ | Column Name | Type | +---------------+---------+ | user_id | int | | post_id | int | | action_date | date | | action | enum | | extra | varchar | +--------------.原创 2020-06-14 04:10:05 · 192 阅读 · 0 评论 -
Employees Earning More Than Their Managers
TheEmployeetable holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id. +----+-------+--------+-----------+ | Id | Name | Salary | ManagerId | +----+-------+--------+-----------+ | 1 | J..原创 2020-05-10 01:57:55 · 163 阅读 · 0 评论 -
Department Top Three Salaries
SQL Schema TheEmployeetable holds all employees. Every employee has an Id, and there is also a column for the department Id. +----+-------+--------+--------------+ | Id | Name | Salary | Departm...原创 2020-04-11 06:16:56 · 126 阅读 · 0 评论 -
Second Highest Salary
Write a SQL query to get the second highest salary from theEmployeetable. +----+--------+ | Id | Salary | +----+--------+ | 1 | 100 | | 2 | 200 | | 3 | 300 | +----+--------+ For exam...原创 2020-03-09 06:17:21 · 106 阅读 · 0 评论