![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Database
大家叫我陈老师
北邮研二在读,研究方向通信算法,关注机器学习
展开
-
【Leetcode Database】Combine Two Tables
【Leetcode Database】Combine Two Tables,本题主要考察数据库的内连接与外连接。原创 2015-05-05 14:55:39 · 474 阅读 · 0 评论 -
【Leetcode Database】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 || 3 | a@b.com |+----+---------+原创 2015-05-05 19:34:38 · 348 阅读 · 0 评论 -
【Leetcode Database】Delete Duplicate Emails
题目:Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest Id.+----+------------------+| Id | Email |+---原创 2015-06-11 10:43:22 · 358 阅读 · 0 评论 -
【Leetcode Database】Employees Earning More Than Their Managers
题目:The Employee table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id.+----+-------+--------+-----------+| Id | Name |原创 2015-06-11 10:54:39 · 427 阅读 · 0 评论