摘要:
Source: https://leetcode.com/problems/big-countries/#/descriptionDescription: There is a table World A country is big if it has an area of bigger than 阅读全文
posted @ 2017-05-21 15:39
sixu
阅读(633)
评论(0)
推荐(0)
摘要:
Source: https://leetcode.com/problems/trips-and-users/#/descriptionDescription: The Trips table holds all taxi trips. Each trip has a unique Id, while 阅读全文
posted @ 2017-05-21 15:30
sixu
阅读(268)
评论(0)
推荐(0)
摘要:
Source: https://leetcode.com/problems/rising-temperature/#/descriptionDescription: Given a Weather table, write a SQL query to find all dates' Ids wit 阅读全文
posted @ 2017-05-21 15:25
sixu
阅读(154)
评论(0)
推荐(0)
摘要:
Source: https://leetcode.com/problems/delete-duplicate-emails/#/descriptionDescription: Write a SQL query to delete all duplicate email entries in a t 阅读全文
posted @ 2017-05-21 15:08
sixu
阅读(166)
评论(0)
推荐(0)
摘要:
Source: https://leetcode.com/problems/department-top-three-salaries/#/description Description: The Employee table holds all employees. Every employee 阅读全文
posted @ 2017-05-21 15:02
sixu
阅读(174)
评论(0)
推荐(0)
摘要:
Source: https://leetcode.com/problems/department-highest-salary/#/descriptionDescription: The Employee table holds all employees. Every employee has a 阅读全文
posted @ 2017-05-21 14:59
sixu
阅读(181)
评论(0)
推荐(0)
摘要:
Source: https://leetcode.com/problems/customers-who-never-order/#/descriptionDescription: Suppose that a website contains two tables, the Customers ta 阅读全文
posted @ 2017-05-21 14:55
sixu
阅读(132)
评论(0)
推荐(0)
摘要:
Source: https://leetcode.com/problems/duplicate-emails/#/descriptionDescription: Write a SQL query to find all duplicate emails in a table named Perso 阅读全文
posted @ 2017-05-21 14:49
sixu
阅读(118)
评论(0)
推荐(0)
摘要:
Source: https://leetcode.com/problems/employees-earning-more-than-their-managers/#/descriptionDescription: The Employee table holds all employees incl 阅读全文
posted @ 2017-05-21 14:36
sixu
阅读(202)
评论(0)
推荐(0)
摘要:
Source: https://leetcode.com/problems/consecutive-numbers/#/descriptionDescription: Write a SQL query to find all numbers that appear at least three t 阅读全文
posted @ 2017-05-21 14:32
sixu
阅读(141)
评论(0)
推荐(0)
摘要:
Source: https://leetcode.com/problems/rank-scores/#/description Description: Write a SQL query to rank scores. If there is a tie between two scores, b 阅读全文
posted @ 2017-05-21 14:07
sixu
阅读(269)
评论(0)
推荐(0)
摘要:
Source: https://leetcode.com/problems/nth-highest-salary/#/descriptionDescription: Write a SQL query to get the nth highest salary from the Employee t 阅读全文
posted @ 2017-05-21 14:02
sixu
阅读(174)
评论(0)
推荐(0)
摘要:
Source: https://leetcode.com/problems/second-highest-salary/#/description Description: Write a SQL query to get the second highest salary from the Emp 阅读全文
posted @ 2017-05-21 13:53
sixu
阅读(176)
评论(0)
推荐(0)
摘要:
Source: https://leetcode.com/problems/combine-two-tables/#/description Description: Table: Person Table: Address Write a SQL query for a report that p 阅读全文
posted @ 2017-05-21 13:48
sixu
阅读(145)
评论(0)
推荐(0)
浙公网安备 33010602011771号