摘要：
Description：The Employee table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id.G... 阅读全文
posted @ 2015-04-16 23:44
Pickle
阅读(212)
评论(0)
推荐(0)
摘要：
Description： Write a SQL query to get the second highest salary from the Employee table.+----+--------+| Id | Salary |+----+--------+| 1 | 100 ||... 阅读全文
posted @ 2015-04-16 23:17
Pickle
阅读(189)
评论(0)
推荐(0)
摘要：
第一次刷SQL题目感觉还是不错的。这个题目（https://leetcode.com/problems/combine-two-tables/）大概是说把第一张表和第二张表连接起来。而且第二张表中的Person的Address中的属性可能为NULL。这明显就是个左外链接。?123# Write yo... 阅读全文
posted @ 2015-04-16 22:50
Pickle
阅读(409)
评论(0)
推荐(0)
摘要：
Description：Write a SQL query for a report that provides the following information for each person in the Person table, regardless if there is an add... 阅读全文
posted @ 2015-04-16 22:48
Pickle
阅读(163)
评论(0)
推荐(0)
浙公网安备 33010602011771号