摘要: Write a SQL query to get a list of tenants who are renting more than one apartment. -- TABLE Apartments -- TABLE Buildings -- TABLE Tenants -- TABLE C 阅读全文
posted @ 2016-04-03 08:32 Grandyang 阅读(591) 评论(0) 推荐(0) 编辑
摘要: Write a SQL query to get the nth highest salary from the Employee table. For example, given the above Employee table, the nth highest salary where n = 阅读全文
posted @ 2016-04-03 05:43 Grandyang 阅读(10388) 评论(0) 推荐(1) 编辑
摘要: Write a SQL query to get the second highest salary from the Employee table. For example, given the above Employee table, the second highest salary is  阅读全文
posted @ 2016-04-03 05:00 Grandyang 阅读(11324) 评论(7) 推荐(1) 编辑
摘要: Table: Person Table: Address Write a SQL query for a report that provides the following information for each person in the Person table, regardless if 阅读全文
posted @ 2016-04-03 04:09 Grandyang 阅读(6318) 评论(0) 推荐(1) 编辑
Fork me on GitHub