极客神殿

坚持,自由,信仰

排序:
默认
按更新时间
按访问量
RSS订阅

LeetCode 数据库262,601整理

The Trips table holds all taxi trips. Each trip has a unique Id, while Client_Id and Driver_Id are both foreign keys to the Users_Id at the Users tab...

2017-07-02 22:59:11

阅读数 1115

评论数 0

LeetCode 数据库181,182,183,184,185整理

181. Employees Earning More Than Their ManagersThe Employee table holds all employees including their managers. Every employee has an Id, and there i...

2017-07-02 18:33:20

阅读数 311

评论数 0

180.Consecutive_Numbers

Write a SQL query to find all numbers that appear at least three times consecutively.#+----+-----+ #| Id | Num | #+----+-----+ #| 1 | 1 | #| 2 | ...

2017-06-29 22:42:30

阅读数 674

评论数 0

178.Rank_Scores

Write a SQL query to rank scores. If there is a tie between two scores, both should have the same ranking. Note that after a tie,the next ranking num...

2017-06-29 21:58:51

阅读数 331

评论数 0

177.Nth_Highest_Salary

Write a SQL query to get the nth highest salary from the Employee table.#+----+--------+ #| Id | Salary | #+----+--------+ #| 1 | 100 | #| 2 | 2...

2017-06-29 21:40:54

阅读数 307

评论数 0

提示
确定要删除当前文章?
取消 删除
关闭
关闭