摘要: 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 阅读(111) 评论(0) 推荐(0) 编辑
摘要: 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 阅读(147) 评论(0) 推荐(0) 编辑
摘要: 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 阅读(119) 评论(0) 推荐(0) 编辑
摘要: 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 阅读(103) 评论(0) 推荐(0) 编辑
摘要: 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 阅读(181) 评论(0) 推荐(0) 编辑
摘要: 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 阅读(161) 评论(0) 推荐(0) 编辑