摘要: leetcode:找到名字重复的邮箱名 Write a SQL query to find all duplicate emails in a table named Person. + + + | Id | Email | + + + | 1 | a@b.com | | 2 | c@d.com | 阅读全文
posted @ 2020-09-27 13:24 菠菜猫 阅读(687) 评论(0) 推荐(0) 编辑
摘要: leetcode: 题目:There is a table courses with columns: student and class Please list out all classes which have more than or equal to 5 students. For exa 阅读全文
posted @ 2020-09-27 12:55 菠菜猫 阅读(509) 评论(0) 推荐(0) 编辑
摘要: leetcode题目: 要求: Given a table salary, such as the one below, that has m=male and f=female values. Swap all f and m values (i.e., change all f values t 阅读全文
posted @ 2020-09-27 12:47 菠菜猫 阅读(959) 评论(0) 推荐(0) 编辑