![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL
搞数据的统计女孩
这个作者很懒,什么都没留下…
展开
-
leetcode刷题记录--SQL
Qustion1 合并两表: Table: Person +-------------+---------+ | Column Name | Type | +-------------+---------+ | PersonId | int | | FirstName | varchar | | LastName | varchar | +-----------...原创 2019-01-04 10:14:59 · 141 阅读 · 0 评论 -
LeetCode ---SQL(easy)(1)
问题二:找出第二高工资 Write a SQL query to get the second highest salary from the Employee table. +----+--------+ | Id | Salary | +----+--------+ | 1 | 100 | | 2 | 200 | | 3 | 300 | +----+----...原创 2019-01-06 17:11:48 · 158 阅读 · 0 评论 -
LeetCode--SQL(easy)(2)
问题:查找重复邮箱 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 | +----+-------...原创 2019-01-11 20:05:50 · 224 阅读 · 0 评论 -
LeetCode--SQL(easy)(3)
问题:找出班级中超过五个学生的课程 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 example, the table: student class A Math...原创 2019-01-21 11:44:06 · 166 阅读 · 1 评论 -
SQL复习———基础
原创 2019-03-10 14:35:20 · 151 阅读 · 0 评论 -
SQL 刷题 (1)
问题一:从titles表获取按照title进行分组,每组个数大于等于2,给出title以及对应的数目t。 CREATE TABLE IF NOT EXISTS "titles" ( `emp_no` int(11) NOT NULL, `title` varchar(50) NOT NULL, `from_date` date NOT NULL, `to_date` date DEFAULT NU...原创 2019-04-21 17:17:44 · 235 阅读 · 0 评论