![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
DataBase
豆先生的成长志
这个作者很懒,什么都没留下…
展开
-
Trips and Users --Hard
Trips表 status是枚举类型 +----+-----------+-----------+---------+--------------------+----------+ | Id | Client_Id | Driver_Id | City_Id | Status |Request_at| +----+-----------+-----------+原创 2015-10-30 19:12:47 · 299 阅读 · 0 评论 -
Rising Temperature--easy
一张Weather表,写出一个SQL语句实现昨天比今天气温高的Id +---------+------------+------------------+ | Id(INT) | Date(DATE) | Temperature(INT) | +---------+------------+------------------+ | 1 | 2015-01-01 |原创 2015-11-01 21:32:20 · 264 阅读 · 0 评论 -
Delete Duplicate Emails---easy
删除Person表中重复的Email,只留下id最小的Email Person表,主键是Id +----+------------------+ | Id | Email | +----+------------------+ | 1 | john@example.com | | 2 | bob@example.com | | 3 | john@example原创 2015-11-02 21:26:34 · 236 阅读 · 0 评论