随笔分类 -  Leetcode-Database 题解

摘要:https://leetcode.com/problems/delete-duplicate-emails/description/ 邮件地址表: + + + | Id | Email | + + + | 1 | a@b.com | | 2 | c@d.com | | 3 | a@b.com | + 阅读全文
posted @ 2019-02-25 11:18 小林子奋斗的点滴 阅读(127) 评论(0) 推荐(0)
摘要:https://leetcode.com/problems/classes-more-than-5-students/description/ + + + | student | class | + + + | A | Math | | B | English | | C | Math | | D 阅读全文
posted @ 2019-02-25 11:03 小林子奋斗的点滴 阅读(203) 评论(0) 推荐(0)
摘要:https://leetcode.com/problems/not-boring-movies/description/ X市开了一家新电影院,很多人都想去这家电影院。电影院还会发布一张海报,说明电影的评级和描述。 请编写一个SQL查询来输出具有奇数编号ID和非“无聊”描述的电影。按评级订购结果。 阅读全文
posted @ 2019-02-25 10:27 小林子奋斗的点滴 阅读(131) 评论(0) 推荐(0)
摘要:https://leetcode.com/problems/swap-salary/description/ | id | name | sex | salary | | | | | | | 1 | A | m | 2500 | | 2 | B | f | 1500 | | 3 | C | m | 阅读全文
posted @ 2019-02-24 10:29 小林子奋斗的点滴 阅读(281) 评论(0) 推荐(0)
摘要:https://leetcode.com/problems/big-countries/description/ 要求: + + + + + + | name | continent | area | population | gdp | + + + + + + | Afghanistan | As 阅读全文
posted @ 2018-12-25 12:36 小林子奋斗的点滴 阅读(178) 评论(0) 推荐(0)