leetcode-database - 随笔分类 - Lorryrui

197. Rising Temperature

摘要：197. Rising Temperature Given a Weather table, write a SQL query to find all dates' Ids with higher temperature compared to its previous (yesterday's) 阅读全文

posted @ 2016-07-15 10:31 Lorryrui 阅读(204) 评论(0) 推荐(0)

181. Employees Earning More Than Their Managers

摘要：181. Employees Earning More Than Their Managers The Employee table holds all employees including their managers. Every employee has an Id, and there i 阅读全文

posted @ 2016-07-14 21:31 Lorryrui 阅读(131) 评论(0) 推荐(0)

183. Customers Who Never Order

摘要：183. Customers Who Never Order Table: Customers. + + +| Id | Name |+ + +| 1 | Joe || 2 | Henry || 3 | Sam || 4 | Max |+ + +Table: Orders. + + +| Id | 阅读全文

posted @ 2016-07-14 20:59 Lorryrui 阅读(182) 评论(0) 推荐(0)

182. Duplicate Emails

摘要：182. Duplicate Emails Write a SQL query to find all duplicate emails in a table named Person. + + +| Id | Email |+ + +| 1 | a@b.com || 2 | c@d.com || 阅读全文

posted @ 2016-07-14 20:35 Lorryrui 阅读(165) 评论(0) 推荐(0)

175. Combine Two Tables

摘要：Table: Person + + +| Column Name | Type |+ + +| PersonId | int || FirstName | varchar || LastName | varchar |+ + +PersonId is the primary key column f 阅读全文

posted @ 2016-07-14 20:34 Lorryrui 阅读(121) 评论(0) 推荐(0)

176. Second Highest Salary

摘要：176. Second Highest Salary Write a SQL query to get the second highest salary from the Employee table. + + +| Id | Salary |+ + +| 1 | 100 || 2 | 200 | 阅读全文

posted @ 2016-07-14 18:37 Lorryrui 阅读(195) 评论(0) 推荐(0)

leetcode--shell

摘要：195. Tenth Line For example, assume that file.txt has the following content: Line 1Line 2Line 3Line 4Line 5Line 6Line 7Line 8Line 9Line 10Your script 阅读全文

posted @ 2016-07-14 08:40 Lorryrui 阅读(183) 评论(0) 推荐(0)

随笔分类 - leetcode-database