摘要: 难度:中等表Employee保存了所有的员工数据。+----+-------+--------+--------------+| Id | Name | Salary | DepartmentId |+----+-------+--------+--------------+| 1 | Joe ... 阅读全文
posted @ 2015-08-24 21:08 -小城- 阅读(602) 评论(0) 推荐(0) 编辑
摘要: 难度:容易写一段SQL,在表Person中查找所有重复的Email地址。+----+---------+| Id | Email |+----+---------+| 1 | a@b.com || 2 | c@d.com || 3 | a@b.com |+----+---------+例如... 阅读全文
posted @ 2015-08-24 21:07 -小城- 阅读(197) 评论(0) 推荐(0) 编辑