sql语句练习50题(Mysql版)

于 2021-01-28 17:33:01 发布
阅读量297 收藏
点赞数
分类专栏： sql 文章标签： mysql ubuntu
原文链接：https://blog.csdn.net/XianZhe_/article/details/113107582
版权

sql语句练习50题(Mysql版)

表名和字段

–1.学生表
Student(s_id,s_name,s_birth,s_sex) --学生编号,学生姓名, 出生年月,学生性别
–2.课程表
Course(c_id,c_name,t_id) – --课程编号, 课程名称, 教师编号
–3.教师表
Teacher(t_id,t_name) --教师编号,教师姓名
–4.成绩表
Score(s_id,c_id,s_score) --学生编号,课程编号,分数
测试数据

–建表
–学生表
CREATE TABLE Student(
s_id VARCHAR(20),
s_name VARCHAR(20) NOT NULL DEFAULT ‘’,
s_birth VARCHAR(20) NOT NULL DEFAULT ‘’,
s_sex VARCHAR(10) NOT NULL DEFAULT ‘’,
PRIMARY KEY(s_id)
);
–课程表
CREATE TABLE Course(
c_id VARCHAR(20),
c_name VARCHAR(20) NOT NULL DEFAULT ‘’,
t_id VARCHAR(20) NOT NULL,
PRIMARY KEY(c_id)
);
–教师表
CREATE TABLE Teacher(
t_id VARCHAR(20),
t_name VARCHAR(20) NOT NULL DEFAULT ‘’,
PRIMARY KEY(t_id)
);
–成绩表
CREATE TABLE Score(
s_id VARCHAR(20),
c_id VARCHAR(20),
s_score INT(3),
PRIMARY KEY(s_id,c_id)
);
–插入学生表测试数据
insert into Student values(‘01’ , ‘赵雷’ , ‘1990-01-01’ , ‘男’);
insert into Student values(‘02’ , ‘钱电’ , ‘1990-12-21’ , ‘男’);
insert into Student values(‘03’ , ‘孙风’ , ‘1990-05-20’ , ‘男’);
insert into Student values(‘04’ , ‘李云’ , ‘1990-08-06’ , ‘男’);
insert into Student values(‘05’ , ‘周梅’ , ‘1991-12-01’ , ‘女’);
insert into Student values(‘06’ , ‘吴兰’ , ‘1992-03-01’ , ‘女’);
insert into Student values(‘07’ , ‘郑竹’ , ‘1989-07-01’ , ‘女’);
insert into Student values(‘08’ , ‘王菊’ , ‘1990-01-20’ , ‘女’);
–课程表测试数据
insert into Course values(‘01’ , ‘语文’ , ‘02’);
insert into Course values(‘02’ , ‘数学’ , ‘01’);
insert into Course values(‘03’ , ‘英语’ , ‘03’);

–教师表测试数据
insert into Teacher values(‘01’ , ‘张三’);
insert into Teacher values(‘02’ , ‘李四’);
insert into Teacher values(‘03’ , ‘王五’);

–成绩表测试数据
insert into Score values(‘01’ , ‘01’ , 80);
insert into Score values(‘01’ , ‘02’ , 90);
insert into Score values(‘01’ , ‘03’ , 99);
insert into Score values(‘02’ , ‘01’ , 70);
insert into Score values(‘02’ , ‘02’ , 60);
insert into Score values(‘02’ , ‘03’ , 80);
insert into Score values(‘03’ , ‘01’ , 80);
insert into Score values(‘03’ , ‘02’ , 80);
insert into Score values(‘03’ , ‘03’ , 80);
insert into Score values(‘04’ , ‘01’ , 50);
insert into Score values(‘04’ , ‘02’ , 30);
insert into Score values(‘04’ , ‘03’ , 20);
insert into Score values(‘05’ , ‘01’ , 76);
insert into Score values(‘05’ , ‘02’ , 87);
insert into Score values(‘06’ , ‘01’ , 31);
insert into Score values(‘06’ , ‘03’ , 34);
insert into Score values(‘07’ , ‘02’ , 89);
insert into Score values(‘07’ , ‘03’ , 98);

练习题和sql语句

– 1、查询"01"课程比"02"课程成绩高的学生的信息及课程分数

select a.* ,b.s_score as 01_score,c.s_score as 02_score from
student a
join score b on a.s_id=b.s_id and b.c_id=‘01’
left join score c on a.s_id=c.s_id and c.c_id=‘02’ or c.c_id = NULL where b.s_score>c.s_score

–也可以这样写
select a.*,b.s_score as 01_score,c.s_score as 02_score from student a,score b,score c
where a.s_id=b.s_id
and a.s_id=c.s_id
and b.c_id=‘01’
and c.c_id=‘02’
and b.s_score>c.s_score
– 2、查询"01"课程比"02"课程成绩低的学生的信息及课程分数

select a.* ,b.s_score as 01_score,c.s_score as 02_score from
student a left join score b on a.s_id=b.s_id and b.c_id=‘01’ or b.c_id=NULL
join score c on a.s_id=c.s_id and c.c_id=‘02’ where b.s_score<c.s_score

– 3、查询平均成绩大于等于60分的同学的学生编号和学生姓名和平均成绩
select b.s_id,b.s_name,ROUND(AVG(a.s_score),2) as avg_score from
student b
join score a on b.s_id = a.s_id
GROUP BY b.s_id,b.s_name HAVING avg_score >=60;

– 4、查询平均成绩小于60分的同学的学生编号和学生姓名和平均成绩
– (包括有成绩的和无成绩的)

select b.s_id,b.s_name,ROUND(AVG(a.s_score),2) as avg_score from
student b
left join score a on b.s_id = a.s_id
GROUP BY b.s_id,b.s_name HAVING avg_score <60
union
select a.s_id,a.s_name,0 as avg_score from
student a
where a.s_id not in (
select distinct s_id from score);

– 5、查询所有同学的学生编号、学生姓名、选课总数、所有课程的总成绩
select a.s_id,a.s_name,count(b.c_id) as sum_course,sum(b.s_score) as sum_score from
student a
left join score b on a.s_id=b.s_id
GROUP BY a.s_id,a.s_name;

– 6、查询"李"姓老师的数量
select count(t_id) from teacher where t_name like ‘李%’;

– 7、查询学过"张三"老师授课的同学的信息
select a.* from
student a
join score b on a.s_id=b.s_id where b.c_id in(
select c_id from course where t_id =(
select t_id from teacher where t_name = ‘张三’));

– 8、查询没学过"张三"老师授课的同学的信息
select * from
student c
where c.s_id not in(
select a.s_id from student a join score b on a.s_id=b.s_id where b.c_id in(
select a.c_id from course a join teacher b on a.t_id = b.t_id where t_name =‘张三’));
– 9、查询学过编号为"01"并且也学过编号为"02"的课程的同学的信息

select a.* from
student a,score b,score c
where a.s_id = b.s_id and a.s_id = c.s_id and b.c_id=‘01’ and c.c_id=‘02’;

– 10、查询学过编号为"01"但是没有学过编号为"02"的课程的同学的信息

select a.* from
student a
where a.s_id in (select s_id from score where c_id=‘01’ ) and a.s_id not in(select s_id from score where c_id=‘02’)

– 11、查询没有学全所有课程的同学的信息
–@wendiepei的写法
select s.* from student s
left join Score s1 on s1.s_id=s.s_id
group by s.s_id having count(s1.c_id)<(select count() from course)
–@k1051785839的写法
select *
from student
where s_id not in(
select s_id from score t1
group by s_id having count() =(select count(distinct c_id) from course))
– 12、查询至少有一门课与学号为"01"的同学所学相同的同学的信息

select * from student where s_id in(
select distinct a.s_id from score a where a.c_id in(select a.c_id from score a where a.s_id=‘01’)
);

– 13、查询和"01"号的同学学习的课程完全相同的其他同学的信息
–@ouyang_1993的写法
SELECT
Student.*
FROM
Student
WHERE
s_id IN (SELECT s_id FROM Score GROUP BY s_id HAVING COUNT(s_id) = (
#下面的语句是找到’01’同学学习的课程数
SELECT COUNT(c_id) FROM Score WHERE s_id = ‘01’
)
)
AND s_id NOT IN (
#下面的语句是找到学过‘01’同学没学过的课程，有哪些同学。并排除他们
SELECT s_id FROM Score
WHERE c_id IN(
#下面的语句是找到‘01’同学没学过的课程
SELECT DISTINCT c_id FROM Score
WHERE c_id NOT IN (
#下面的语句是找出‘01’同学学习的课程
SELECT c_id FROM Score WHERE s_id = ‘01’
)
) GROUP BY s_id
) #下面的条件是排除01同学
AND s_id NOT IN (‘01’)
–@k1051785839的写法
SELECT
t3.*
FROM
(
SELECT
s_id,
group_concat(c_id ORDER BY c_id) group1
FROM
score
WHERE
s_id <> ‘01’
GROUP BY
s_id
) t1
INNER JOIN (
SELECT
group_concat(c_id ORDER BY c_id) group2
FROM
score
WHERE
s_id = ‘01’
GROUP BY
s_id
) t2 ON t1.group1 = t2.group2
INNER JOIN student t3 ON t1.s_id = t3.s_id

– 14、查询没学过"张三"老师讲授的任一门课程的学生姓名
select a.s_name from student a where a.s_id not in (
select s_id from score where c_id =
(select c_id from course where t_id =(
select t_id from teacher where t_name = ‘张三’)));

– 15、查询两门及其以上不及格课程的同学的学号，姓名及其平均成绩
select a.s_id,a.s_name,ROUND(AVG(b.s_score)) from
student a
left join score b on a.s_id = b.s_id
where a.s_id in(
select s_id from score where s_score<60 GROUP BY s_id having count(1)>=2)
GROUP BY a.s_id,a.s_name

– 16、检索"01"课程分数小于60，按分数降序排列的学生信息
select a.*,b.c_id,b.s_score from
student a,score b
where a.s_id = b.s_id and b.c_id=‘01’ and b.s_score<60 ORDER BY b.s_score DESC;

– 17、按平均成绩从高到低显示所有学生的所有课程的成绩以及平均成绩
select a.s_id,(select s_score from score where s_id=a.s_id and c_id=‘01’) as 语文,
(select s_score from score where s_id=a.s_id and c_id=‘02’) as 数学,
(select s_score from score where s_id=a.s_id and c_id=‘03’) as 英语,
round(avg(s_score),2) as 平均分 from score a GROUP BY a.s_id ORDER BY 平均分 DESC;
–@喝完这杯还有一箱的写法
SELECT a.s_id,MAX(CASE a.c_id WHEN ‘01’ THEN a.s_score END ) 语文,
MAX(CASE a.c_id WHEN ‘02’ THEN a.s_score END ) 数学,
MAX(CASE a.c_id WHEN ‘03’ THEN a.s_score END ) 英语,
avg(a.s_score),b.s_name FROM Score a JOIN Student b ON a.s_id=b.s_id GROUP BY a.s_id ORDER BY 5 DESC
– 18.查询各科成绩最高分、最低分和平均分：以如下形式显示：课程ID，课程name，最高分，最低分，平均分，及格率，中等率，优良率，优秀率
–及格为>=60，中等为：70-80，优良为：80-90，优秀为：>=90
select a.c_id,b.c_name,MAX(s_score),MIN(s_score),ROUND(AVG(s_score),2),
ROUND(100*(SUM(case when a.s_score>=60 then 1 else 0 end)/SUM(case when a.s_score then 1 else 0 end)),2) as 及格率,
ROUND(100*(SUM(case when a.s_score>=70 and a.s_score<=80 then 1 else 0 end)/SUM(case when a.s_score then 1 else 0 end)),2) as 中等率,
ROUND(100*(SUM(case when a.s_score>=80 and a.s_score<=90 then 1 else 0 end)/SUM(case when a.s_score then 1 else 0 end)),2) as 优良率,
ROUND(100*(SUM(case when a.s_score>=90 then 1 else 0 end)/SUM(case when a.s_score then 1 else 0 end)),2) as 优秀率
from score a left join course b on a.c_id = b.c_id GROUP BY a.c_id,b.c_name

– 19、按各科成绩进行排序，并显示排名
– mysql没有rank函数
select a.s_id,a.c_id,
@i:=@i +1 as i保留排名,
@k:=(case when @score=a.s_score then @k else @i end) as rank不保留排名,
@score:=a.s_score as score
from (
select s_id,c_id,s_score from score GROUP BY s_id,c_id,s_score ORDER BY s_score DESC
)a,(select @k:=0,@i:=0,@score:=0)s
–@k1051785839的写法
(select * from (select
t1.c_id,
t1.s_score,
(select count(distinct t2.s_score) from score t2 where t2.s_score>=t1.s_score and t2.c_id=‘01’) rank
FROM score t1 where t1.c_id=‘01’
order by t1.s_score desc) t1)
union
(select * from (select
t1.c_id,
t1.s_score,
(select count(distinct t2.s_score) from score t2 where t2.s_score>=t1.s_score and t2.c_id=‘02’) rank
FROM score t1 where t1.c_id=‘02’
order by t1.s_score desc) t2)
union
(select * from (select
t1.c_id,
t1.s_score,
(select count(distinct t2.s_score) from score t2 where t2.s_score>=t1.s_score and t2.c_id=‘03’) rank
FROM score t1 where t1.c_id=‘03’
order by t1.s_score desc) t3)
– 20、查询学生的总成绩并进行排名
select a.s_id,
@i:=@i+1 as i,
@k:=(case when @score=a.sum_score then @k else @i end) as rank,
@score:=a.sum_score as score
from (select s_id,SUM(s_score) as sum_score from score GROUP BY s_id ORDER BY sum_score DESC)a,
(select @k:=0,@i:=0,@score:=0)s

– 21、查询不同老师所教不同课程平均分从高到低显示

select a.t_id,c.t_name,a.c_id,ROUND(avg(s_score),2) as avg_score from course a
	left join score b on a.c_id=b.c_id 
	left join teacher c on a.t_id=c.t_id
	GROUP BY a.c_id,a.t_id,c.t_name ORDER BY avg_score DESC;

– 22、查询所有课程的成绩第2名到第3名的学生信息及该课程成绩

		select d.*,c.排名,c.s_score,c.c_id from (
            select a.s_id,a.s_score,a.c_id,@i:=@i+1 as 排名 from score a,(select @i:=0)s where a.c_id='01'  
							ORDER BY a.s_score DESC  
        )c
        left join student d on c.s_id=d.s_id
        where 排名 BETWEEN 2 AND 3
        UNION
        select d.*,c.排名,c.s_score,c.c_id from (
            select a.s_id,a.s_score,a.c_id,@j:=@j+1 as 排名 from score a,(select @j:=0)s where a.c_id='02'  
							ORDER BY a.s_score DESC
        )c
        left join student d on c.s_id=d.s_id
        where 排名 BETWEEN 2 AND 3
        UNION
        select d.*,c.排名,c.s_score,c.c_id from (
            select a.s_id,a.s_score,a.c_id,@k:=@k+1 as 排名 from score a,(select @k:=0)s where a.c_id='03' 
							ORDER BY a.s_score DESC
        )c
        left join student d on c.s_id=d.s_id
        where 排名 BETWEEN 2 AND 3;

– 23、统计各科成绩各分数段人数：课程编号,课程名称,[100-85],[85-70],[70-60],[0-60]及所占百分比

	select distinct f.c_name,a.c_id,b.`85-100`,b.百分比,c.`70-85`,c.百分比,d.`60-70`,d.百分比,e.`0-60`,e.百分比 from score a
			left join (select c_id,SUM(case when s_score >85 and s_score <=100 then 1 else 0 end) as `85-100`,
										ROUND(100*(SUM(case when s_score >85 and s_score <=100 then 1 else 0 end)/count(*)),2) as 百分比
							from score GROUP BY c_id)b on a.c_id=b.c_id
			left join (select c_id,SUM(case when s_score >70 and s_score <=85 then 1 else 0 end) as `70-85`,
										ROUND(100*(SUM(case when s_score >70 and s_score <=85 then 1 else 0 end)/count(*)),2) as 百分比
							from score GROUP BY c_id)c on a.c_id=c.c_id
			left join (select c_id,SUM(case when s_score >60 and s_score <=70 then 1 else 0 end) as `60-70`,
										ROUND(100*(SUM(case when s_score >60 and s_score <=70 then 1 else 0 end)/count(*)),2) as 百分比
							from score GROUP BY c_id)d on a.c_id=d.c_id
			left join (select c_id,SUM(case when s_score >=0 and s_score <=60 then 1 else 0 end) as `0-60`,
										ROUND(100*(SUM(case when s_score >=0 and s_score <=60 then 1 else 0 end)/count(*)),2) as 百分比
							from score GROUP BY c_id)e on a.c_id=e.c_id
			left join course f on a.c_id = f.c_id

– 24、查询学生平均成绩及其名次

	select a.s_id,
			@i:=@i+1 as '不保留空缺排名',
			@k:=(case when @avg_score=a.avg_s then @k else @i end) as '保留空缺排名',
			@avg_score:=avg_s as '平均分'
	from (select s_id,ROUND(AVG(s_score),2) as avg_s from score GROUP BY s_id ORDER BY avg_s DESC)a,(select @avg_score:=0,@i:=0,@k:=0)b;

– 25、查询各科成绩前三名的记录
– 1.选出b表比a表成绩大的所有组
– 2.选出比当前id成绩大的 小于三个的
select a.s_id,a.c_id,a.s_score from score a
left join score b on a.c_id = b.c_id and a.s_score<b.s_score
group by a.s_id,a.c_id,a.s_score HAVING COUNT(b.s_id)❤️
ORDER BY a.c_id,a.s_score DESC

– 26、查询每门课程被选修的学生数

	select c_id,count(s_id) from score a GROUP BY c_id

– 27、查询出只有两门课程的全部学生的学号和姓名
select s_id,s_name from student where s_id in(
select s_id from score GROUP BY s_id HAVING COUNT(c_id)=2);

– 28、查询男生、女生人数
select s_sex,COUNT(s_sex) as 人数 from student GROUP BY s_sex

– 29、查询名字中含有"风"字的学生信息

	select * from student where s_name like '%风%';

– 30、查询同名同性学生名单，并统计同名人数

	select a.s_name,a.s_sex,count(*) from student a  JOIN 
				student b on a.s_id !=b.s_id and a.s_name = b.s_name and a.s_sex = b.s_sex
	GROUP BY a.s_name,a.s_sex

– 31、查询1990年出生的学生名单

	select s_name from student where s_birth like '1990%'

– 32、查询每门课程的平均成绩，结果按平均成绩降序排列，平均成绩相同时，按课程编号升序排列

select c_id,ROUND(AVG(s_score),2) as avg_score from score GROUP BY c_id ORDER BY avg_score DESC,c_id ASC

– 33、查询平均成绩大于等于85的所有学生的学号、姓名和平均成绩

select a.s_id,b.s_name,ROUND(avg(a.s_score),2) as avg_score from score a
	left join student b on a.s_id=b.s_id GROUP BY s_id HAVING avg_score>=85

– 34、查询课程名称为"数学"，且分数低于60的学生姓名和分数

	select a.s_name,b.s_score from score b join student a on a.s_id=b.s_id where b.c_id=(
				select c_id from course where c_name ='数学') and b.s_score<60

– 35、查询所有学生的课程及分数情况；

	select a.s_id,a.s_name,
				SUM(case c.c_name when '语文' then b.s_score else 0 end) as '语文',
				SUM(case c.c_name when '数学' then b.s_score else 0 end) as '数学',
				SUM(case c.c_name when '英语' then b.s_score else 0 end) as '英语',
				SUM(b.s_score) as  '总分'
	from student a left join score b on a.s_id = b.s_id 
	left join course c on b.c_id = c.c_id 
	GROUP BY a.s_id,a.s_name

– 36、查询任何一门课程成绩在70分以上的姓名、课程名称和分数；
select a.s_name,b.c_name,c.s_score from course b left join score c on b.c_id = c.c_id
left join student a on a.s_id=c.s_id where c.s_score>=70

– 37、查询不及格的课程
select a.s_id,a.c_id,b.c_name,a.s_score from score a left join course b on a.c_id = b.c_id
where a.s_score<60

–38、查询课程编号为01且课程成绩在80分以上的学生的学号和姓名；
select a.s_id,b.s_name from score a LEFT JOIN student b on a.s_id = b.s_id
where a.c_id = ‘01’ and a.s_score>80

– 39、求每门课程的学生人数
select count(*) from score GROUP BY c_id;

– 40、查询选修"张三"老师所授课程的学生中，成绩最高的学生信息及其成绩

	-- 查询老师id	
	select c_id from course c,teacher d where c.t_id=d.t_id and d.t_name='张三'
	-- 查询最高分（可能有相同分数）
	select MAX(s_score) from score where c_id='02'
	-- 查询信息
	select a.*,b.s_score,b.c_id,c.c_name from student a
		LEFT JOIN score b on a.s_id = b.s_id
		LEFT JOIN course c on b.c_id=c.c_id
		where b.c_id =(select c_id from course c,teacher d where c.t_id=d.t_id and d.t_name='张三')
		and b.s_score in (select MAX(s_score) from score where c_id='02')

– 41、查询不同课程成绩相同的学生的学生编号、课程编号、学生成绩
select DISTINCT b.s_id,b.c_id,b.s_score from score a,score b where a.c_id != b.c_id and a.s_score = b.s_score

– 42、查询每门功成绩最好的前两名
– 牛逼的写法
select a.s_id,a.c_id,a.s_score from score a
where (select COUNT(1) from score b where b.c_id=a.c_id and b.s_score>=a.s_score)<=2 ORDER BY a.c_id

– 43、统计每门课程的学生选修人数（超过5人的课程才统计）。要求输出课程号和选修人数，查询结果按人数降序排列，若人数相同，按课程号升序排列
select c_id,count(*) as total from score GROUP BY c_id HAVING total>5 ORDER BY total,c_id ASC

– 44、检索至少选修两门课程的学生学号
select s_id,count(*) as sel from score GROUP BY s_id HAVING sel>=2

– 45、查询选修了全部课程的学生信息
select * from student where s_id in(
select s_id from score GROUP BY s_id HAVING count()=(select count() from course))

–46、查询各学生的年龄
– 按照出生日期来算，当前月日 < 出生年月的月日则，年龄减一

select s_birth,(DATE_FORMAT(NOW(),'%Y')-DATE_FORMAT(s_birth,'%Y') - 
			(case when DATE_FORMAT(NOW(),'%m%d')>DATE_FORMAT(s_birth,'%m%d') then 0 else 1 end)) as age
	from student;

– 47、查询本周过生日的学生
select * from student where WEEK(DATE_FORMAT(NOW(),’%Y%m%d’))=WEEK(s_birth)
select * from student where YEARWEEK(s_birth)=YEARWEEK(DATE_FORMAT(NOW(),’%Y%m%d’))

select WEEK(DATE_FORMAT(NOW(),'%Y%m%d'))

– 48、查询下周过生日的学生
select * from student where WEEK(DATE_FORMAT(NOW(),’%Y%m%d’))+1 =WEEK(s_birth)

– 49、查询本月过生日的学生

select * from student where MONTH(DATE_FORMAT(NOW(),'%Y%m%d')) =MONTH(s_birth)

– 50、查询下月过生日的学生
select * from student where MONTH(DATE_FORMAT(NOW(),’%Y%m%d’))+1 =MONTH(s_birth)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416

点赞 399
评论 459
分享
收藏 1665
举报
关注

一键三连

MySQL等 SQL语句在线练习
大数据开发
5万+
SQL语句在线练习 http://sample.jimstone.com.cn/xsql/ SQL语句测验 http://www.w3school.com.cn/quiz/quiz.asp?quiz=sql sql语句练习50题(Mysql版) https://blog.csdn.net/fashion2014/article/details/78826299/ htt…
表情包

Zoro_16
Zoro_16:第一题差点给我劝退了......2 年前回复
[点赞] 87
    qq_41795056
    码工 [码工] 宫廷白开水回复bmync:

        SELECT
        	st.s_id,st.s_name,st.s_birth,st.s_sex,sc.s_score as score1,scc.s_score as score2
        FROM
        	Student st
        	LEFT JOIN Score sc ON st.s_id = sc.s_id AND sc.c_id = '01'
        	LEFT JOIN Score scc ON st.s_id = scc.s_id And scc.c_id = '02'
        	WHERE IFNULL(sc.s_score,0) > IFNULL(scc.s_score,0)

    是01课比02课分数大，不过不伤大雅1 月前回复
    [点赞]
    bmync
    bmync回复杰小生:

        SELECT
        	* 
        FROM
        	Student st
        	LEFT JOIN Score sc ON st.s_id = sc.s_id AND sc.c_id = '01'
        	LEFT JOIN Score scc ON st.s_id = scc.s_id And scc.c_id = '02'
        	WHERE IFNULL(sc.s_score,0) < IFNULL(scc.s_score,0)

    两种思路，第一种查询时间太太太久了，还有感觉答案不够严谨，我用了一周的时间，太菜了1 月前回复
    [点赞] 1
    bmync
    bmync回复杰小生:

        SELECT
        	* 
        FROM
        	(
        	SELECT
        		sts.*,
        		s.s_score 
        	FROM
        		( SELECT * FROM Student st CROSS JOIN Course c ) sts
        		LEFT JOIN Score s ON sts.s_id = s.s_id 
        		AND s.c_id = sts.c_id 
        	) AS datatable
        	JOIN (
        	SELECT
        		sts.*,
        		s.s_score 
        	FROM
        		( SELECT * FROM Student st CROSS JOIN Course c ) sts
        		LEFT JOIN Score s ON sts.s_id = s.s_id 
        		AND s.c_id = sts.c_id 
        	) AS aa ON aa.s_id = datatable.s_id 
        	AND datatable.c_id = '01' 
        	AND aa.c_id = "02" 
        	AND IFNULL( datatable.s_score, 0 ) > IFNULL(
        	aa.s_score,
        	0)

    1 月前回复
    [点赞]
    weixin_43673660
    杰小生回复杰小生:傻瓜我,这不就行了:

        select Student.s_id 学生编号,Student.s_name 学生姓名,A.`平均成绩` from 
        (SELECT s_id,avg(s_score) 平均成绩 FROM Score  group by s_id having AVG(s_score) >= 60) A 
        left join Student
        on A.s_id = Student.s_id;

    2 月前回复
    [点赞]
    weixin_43673660
    杰小生回复杰小生:

        -- 3、查询平均成绩大于等于60分的同学的学生编号和学生姓名和平均成绩
        select Student.s_id 学生编号,Student.s_name 学生姓名,A.`平均成绩` from 
        (SELECT Student.s_name,avg(s_score) 平均成绩 FROM Score LEFT JOIN Student ON Student.s_id = Score.s_id group by s_name having AVG(s_score) >= 60) A 
        left join Student
        on A.s_name = Student.s_name;

    2 月前回复
    [点赞]
    weixin_43673660
    杰小生回复杰小生:

        -- 2、查询"01"课程比"02"课程成绩低的学生的信息及课程分数
        -- 思路与第一题一致,条件换下就行了
        select A.s_name,语文,数学 from 
        (SELECT c_id,s_score 语文,s_name FROM Score LEFT JOIN Student ON Student.s_id = Score.s_id WHERE c_id = 01)  A
        join
        (SELECT c_id,s_score 数学,s_name FROM Score LEFT JOIN Student ON Student.s_id = Score.s_id WHERE c_id = 02)  B
        on
        A.s_name = B.s_name where 语文 < 数学;

    2 月前回复
    [点赞]
    weixin_43673660
    杰小生回复杰小生:

        select A.s_name,语文,数学 from 
        (SELECT c_id,s_score 语文,s_name FROM Score LEFT JOIN Student ON Student.s_id = Score.s_id WHERE c_id = 01)  A
        join
        (SELECT c_id,s_score 数学,s_name FROM Score LEFT JOIN Student ON Student.s_id = Score.s_id WHERE c_id = 02)  B
        on
        A.s_name = B.s_name where 语文 < 数学;

    2 月前回复
    [点赞]
    weixin_43673660
    杰小生回复:

        -- 1、查询"01"课程比"02"课程成绩高的学生的信息及课程分数
        select A.s_name,语文,数学 from 
        (SELECT c_id,s_score 语文,s_name FROM Score LEFT JOIN Student ON Student.s_id = Score.s_id WHERE c_id = 01)  A
        join
        (SELECT c_id,s_score 数学,s_name FROM Score LEFT JOIN Student ON Student.s_id = Score.s_id WHERE c_id = 02)  B
        on
        A.s_name = B.s_name where 语文 >数学;

    2 月前回复
    [点赞]
    weixin_43673660
    杰小生回复:已经劝退了2 月前回复
    [点赞]
    sinat_37676560
    码哥 [码哥] chen_mg回复码上圆梦:哈哈哈，从后面做起，咸鱼翻身4 月前回复
    [点赞]
    weixin_44897262
    码上圆梦回复窝窝头，:豪气风发来找题,第一题干废了...5 月前回复
    [点赞] 2
    weixin_44844568
    几月的云回复:+16 月前回复
    [点赞]
    weixin_48992500
    weixin_48992500回复:+16 月前回复
    [点赞]
    zhccjun
    zhccjun回复:第一题竟然是我前几天的笔试题 ，上次没做出来这次也没做出来，嗨呀。7 月前回复
    [点赞] 2
    qq_42195733
    那就试试就逝世回复:太TM真实了7 月前回复
    [点赞] 1
    qq_41093779
    优秀的仙回复:就看了第一题我就知道我啥水平了8 月前回复
    [点赞] 2
    treblez
    码哥 [码哥] treble-z回复车大炮鸡仔:学一下内联外联就好了9 月前回复
    [点赞]
    jinyuheng1987
    车大炮鸡仔回复:第一题的第一个查询方法我还真看不懂，第二方方法还好。10 月前回复
    [点赞] 1
    valkyrja110
    valkyrja110回复:第一题想了1个小时，才弄出来。。。。。。终于知道自己是什么水平了10 月前回复
    [点赞]
    weixin_45046849
    weixin_45046849回复: +1才知道自连接可以一个表当俩个表用2 年前回复
    [点赞]
    weixin_39941448
    好大的风啊回复: 卧槽，我以为只有我才这么认为2 年前回复
    [点赞] 1
    qq_34713259
    俄亥俄州还给鹅回复: +12 年前回复
    [点赞]
    Adongbb
    Adong董雪鹏回复: +100862 年前回复
    [点赞]
    qq_42538451
    榴莲啊千层回复窝窝头，: +12 年前回复
    [点赞] 1
    Oh_Sun
    窝窝头，回复: 同感 哈哈哈哈2 年前回复
    [点赞] 1

L_Dragon66
L_Dragon66:第4题这样写简洁些吧

    select
        S.s_id,
        S.s_name,
        round(avg(ifnull(C.s_score,0)),2) as avg_score
    from
        Student S
    left join Score C
    on S.s_id = C.s_id
    group by s_id
    having avg_score < 60;

2 年前回复
[点赞] 14
    qq_38859454
    九歌_jason回复danny_hh:对6 月前回复
    [点赞] 1
    jiulou_1965
    jiulou_1965回复danny_hh:它有ifnull7 月前回复
    [点赞]
    danny_hh
    danny_hh回复:#4、查询平均成绩小于60分的同学的学生编号和学生姓名和平均成绩(包括有成绩的和无成绩的) select a.s_id,a.s_name,ROUND(AVG(b.s_score),2) as avg_score from student a left join score b on a.s_id = b.s_id GROUP BY a.s_id HAVING avg_score < 60 or avg_score is null; 添加个null的判断才全8 月前回复
    [点赞] 1

Ohuo_Chen
二三哟:13题：

    SELECT
     Student.*
    FROM
     Student
    WHERE
     s_id IN (select s_id from score GROUP BY s_id HAVING GROUP_CONCAT(c_id) = (    
         SELECT GROUP_CONCAT(c_id) FROM Score WHERE s_id = '01')
     );

2 年前回复
[点赞] 6
    xwxyxxubo
    Snails_Rocket回复:大佬，都没见过GROUP_CONCAT()函数2 月前回复
    [点赞]
    weixin_43992119
    此湖不结冰回复:你这个需要对c_id 经行排序 这样才能保证 相等时 是一样的7 月前回复
    [点赞] 1
    happenwhat
    second_ming回复:这个结果没有排除 学生编号为“01”，你可以再看下1 年前回复
    [点赞]
    three_thing
    three_thing回复: 大佬，这里有个问题，就是你在聚集的时候，01 学号生成的是01，02，03，但是如果02学号的学生生成的可能是02，01，03，课程一样，但是结果不相等2 年前回复
    [点赞] 2
    three_thing
    three_thing回复: 大佬，受我一拜2 年前回复
    [点赞]
    weixin_38688399
    xxZkj回复: 大佬给跪了2 年前回复
    [点赞]
    Zero_Dream2019
    Zero_Dream2019回复: 牛逼牛逼2 年前回复
    [点赞]
    aishuijiaodemao
    练不出腹肌不改头像回复: 大佬受我一拜2 年前回复
    [点赞]
    qq_35297408
    qq_35297408回复: 牛逼,学习了2 年前回复
    [点赞]
    User_Yr
    全球变暖i回复: HAVING那一块儿 改成 HAVING s_id <> '01' AND GROUP_CONCAT(c_id)等等2 年前回复
    [点赞] 1

three_thing
three_thing:13题: 参考：二三哟，他没有注意到如果c_id 顺序不一样的情况，比如 01号学生课程拼接顺序是 01，02,03，但是02号学生是02,01,03，用他的sql会出现问题，因此每次拼接都进行排序拼接，修改后代码如下：

    SELECT
    	*
    FROM
    	student
    WHERE
    	s_id IN (SELECT s_id FROM score GROUP BY s_id HAVING group_concat(c_id ORDER BY c_id) = (
    				SELECT group_concat(c.c_id ORDER BY c_id) FROM score c WHERE c.s_id = '01' ));

2 年前回复
[点赞] 5
    a1385341
    水手怕水回复second_ming:默认数据不排序没问题，考虑现实情况得排序2 月前回复
    [点赞]
    qq_27817541
    qq_27817541回复second_ming:您好，我这边测试下来不排序的话是有问题的...4 月前回复
    [点赞]
    happenwhat
    second_ming回复:已经测试，在group_concat 内部不需要排序，二三呦的回答，除了没有过滤“01“，其他都ok1 年前回复
    [点赞]
    weixin_33725423
    180810回复: 加个过滤学号01的条件就更好了，思路很好。哈哈2 年前回复
    [点赞] 1

weixin_43286545
weixin_43286545:19题 这样看上去更明白

    SELECT
     @i :=(case when @o != a.c_id then 1 else @i+1 end) as rank,
    	@o :=a.c_id as c_id,
    	a.s_score as score
    FROM
    	(
    SELECT
    	s.c_id,
    	s.s_score 
    FROM
    	score s 
    GROUP BY
    	s.c_id,
    	s.s_score 
    ORDER BY
    	s.c_id,
    	s.s_score DESC 
    	) a,
    	( SELECT @i := 0, @o := 0 ) s

2 年前回复
[点赞] 5
    Cassiel_f
    Cassiel1106回复:s_id字段没有显示，但是加上s_id字段之后就又没法按c_id分组后显示每组排名了7 月前回复
    [点赞]
    weixin_41644564
    weixin_41644564回复: nice,懂了!2 年前回复
    [点赞] 

weixin_44751637
代码量和薪资成正比:从事数据库开发一年，第一题都不会。6 月前回复
[点赞] 3
    yuzx88
    yuzx88回复:哈哈 真实6 月前回复
    [点赞] 1

weixin_43286545
weixin_43286545:22、查询所有课程的成绩第2名到第3名的学生信息及该课程成绩，这个题，在03课程下的结果有问题，应该少了一个人

    SELECT
    	s.s_id,s2.s_name,s.s_score,s.c_id
    FROM
    	score s,student s2
    WHERE
     s.s_id = s2.s_id
     and
    	s.s_score IN (select * from (
    SELECT
    	s.s_score 
    FROM
    	score s 
    WHERE
    	s.c_id = '01' 
    GROUP BY
    	s.c_id,
    	s.s_score 
    ORDER BY
    	s.c_id,
    	s.s_score DESC 
    	LIMIT 1,2 ) as a
    	) 
    	AND s.c_id = '01'
    	UNION
    	SELECT
    	s.s_id,s2.s_name,s.s_score,s.c_id
    FROM
    	score s,student s2
    WHERE
     s.s_id = s2.s_id
     and
    	s.s_score IN (select * from (
    SELECT
    	s.s_score 
    FROM
    	score s 
    WHERE
    	s.c_id = '02' 
    GROUP BY
    	s.c_id,
    	s.s_score 
    ORDER BY
    	s.c_id,
    	s.s_score DESC 
    	LIMIT 1,2 ) as a
    	) 
    	AND s.c_id = '02'
    	UNION
    		SELECT
    	s.s_id,s2.s_name,s.s_score,s.c_id
    FROM
    	score s,student s2
    WHERE
     s.s_id = s2.s_id
     and
    	s.s_score IN (select * from (
    SELECT
    	s.s_score 
    FROM
    	score s 
    WHERE
    	s.c_id = '03' 
    GROUP BY
    	s.c_id,
    	s.s_score 
    ORDER BY
    	s.c_id,
    	s.s_score DESC 
    	LIMIT 1,2 ) as a
    	) 
    	AND s.c_id = '03'

2 年前回复
[点赞] 3
    bsfz_2018
    猫咪很喜欢喝的咖啡是java回复:你和题主答案都有错，课程1和课程3的80分都是两个人，并列，课程1是并列第一，不存在第二名，76就是第三名。应该这么写

        select c.s_id,c.s_score,c.c_id,c.rank from(
        select a.s_id,a.s_score,a.c_id,@inRank:=if(@prevSubject=a.c_id,@inRank+1,1),@rank:=if(@preScore=a.s_score,@rank,@inRank) as rank,@preScore:=a.s_score,@prevSubject:=a.c_id from score a,(select @rank:=0,@inRank:=0,@preScore:=null,@prevSubject:=null)b order by a.c_id,a.s_score desc
        )c where c.rank in(2,3) order by c.c_id ;

    1 月前回复
    [点赞]
    weixin_45681907
    weixin_45681907回复:你这个结果是对的，厉害厉害1 年前回复
    [点赞] 

weixin_42838636
OrangeBling~:第一题第一种解法:

    or c.c_id = NULL

认为可以不添加吧,因为是已经是左外连接了,会把选修课程1但是没选课程2的同学筛选出来,并且觉得第二个直接用内连接join会更好一些吧2 年前回复
[点赞] 3
    qq_25443541
    尤尔小屋的猫回复:代码好像有问题吧？查不出某个学生有01科目的成绩，但是02科目不存在的学生，比如：06号学生2 月前回复
    [点赞]
    m0_45410658
    m0_45410658回复: 我也感觉是啊2 年前回复
    [点赞] 

weixin_42312342
帮我消消黑眼圈！:有哪位大佬知道,为什么第一二里面要加or c.c_id = NULL,不加也能查不来呀2 年前回复
[点赞] 3
    weter_drop
    码农 [码农] ratelfu回复码哥 [码哥] 慕飞烟:

        SELECT
        	a.*,
        	b.s_score AS 01_score,
        	c.s_score AS 02_score 
        FROM
        	student a
        	JOIN score b ON a.s_id = b.s_id 
        	AND b.c_id = '01'
        	LEFT JOIN score c ON a.s_id = c.s_id 
        	AND c.c_id = '02' 
        	OR c.c_id = NULL 
        WHERE
        	b.s_score > c.s_score
m0_50125842
关注
专栏目录
mysql 语句练习笔记
Qve1995的博客
08-30 854
-- 1、查询"01"课程比"02"课程成绩高的学生的信息及课程分数 SELECT a.*,b.s_score as '01-课程',c.s_score as '02-课程' FROM student a JOIN score b on a.s_id = b.s_id AND b.c_id = '01' LEFT JOIN score c on a.s_id = c.s_id AND c.c_id='02' OR c.c_id=NULL WHERE b.s_score > c.s_score ..
sql modify 会丢失数据么_面试数据分析会遇到的SQL题
weixin_39732249的博客
11-24 375
「1」说在前面数据存放在数据库里，以表的形式分门别类。宜家的商品（数据）放在宜家的仓库（数据库）里，以货位的形式分门别类。在宜家，可以通过商品上的编号，查到商品在仓库的排号和位号，取到商品。SQL 语言是一种通用的数据库查询语言，可以通过 SQL 语言从数据库里获取到想要的数据内容。巧妇难为无米之炊。这是数据分析师拿到“米”的重要技能，所以说 SQL 语言对于数据分析从业者来说很重要。SQL 语言...
考试记录（数据库）
小白
10-15 780
INSERT student (sid,sname,sex,birth,classes) VALUE (1001,"张三",1,"1998-7-1",1801) ; UPDATE student SET classes = 1802 WHERE sname LIKE "张三" ; DELETE FROM student WHERE sname = "张三" AND classes = 1802 ; SELECT * FROM student ; SELECT * FROM student WHER.
2020-11-20
FXS000的博客
11-20 165
9.查询“001”课程比“002”课程成绩高的所有学生的学号； select a.s_id from (select s_id,score from SC where C_ID=‘001’) a,(select s_id,scorefrom SC where C_ID=‘002’) b where a.score>b.score and a.s_id=b.s_id; 10.查询平均成绩大于60分的同学的学号和平均成绩； select S_ID,avg(score) from sc group by S
SQL语句练习50题(MySQL版)
sincegc的博客
08-07 136
表名和字段 –1.学生表 Student(s_id,s_name,s_birth,s_sex) --学生编号,学生姓名, 出生年月,学生性别 –2.课程表 Course(c_id,c_name,t_id) – --课程编号, 课程名称, 教师编号 –3.教师表 Teacher(t_id,t_name) --教师编号,教师姓名 –4.成绩表 Score(s_id,c_id,s_score) --学生...
MySQL SQL语句练习题及答案
12-21
MySQL SQL语句练习题及答案 本资源提供了 MySQL SQL 语句的练习题及答案，涵盖了创建表、插入数据、删除数据、更新数据、查询数据等多方面的知识点。 一、创建表 在 MySQL 中，创建表使用 CREATE TABLE 语句。...
最全sql查询语句练习题汇总(面试必备)
07-07
最全sql查询语句练习题汇总(面试必备) 最全sql查询语句练习题汇总(面试必备) 最全sql查询语句练习题汇总(面试必备) 最全sql查询语句练习题汇总(面试必备) 最全sql查询语句练习题汇总(面试必备) 最全sql查询语句练习...
SQL语句练习-50题
04-07
根据给定文件中的内容，我们可以将相关知识点概括并详述如下： ### 1. SQL基础知识 #### 1.1 数据库表的创建 (CREATE TABLE) ...此外，这些知识点也适用于其他类型的数据库系统，如MySQL、Oracle等。
MySQL练习代码， sql语句练习3
最新发布
06-17
总的来说，“MySQL练习代码，sql语句练习3”将引导你深入理解SQL语言的各个方面，通过实践来提升你的数据库管理和查询技能。无论你是初学者还是经验丰富的开发者，这样的练习都将帮助你巩固理论知识，提高实际操作...
数据分析sql面试必会6题经典_SQL面试经典50题带你从建表开始
weixin_39778668的博客
12-18 317
SQL面试经典50题带你从建表开始大家好，相信很多学习数据分析的小伙伴在面试前都经历过刷题，本系列小编将带大家一起来刷一刷SQL面试必会的经典50题。当然本系列文章不单单是刷题，小编会带着大家梳理一下解题时用到的知识点，所以基础比较差的小伙伴也完全不必担心，小编会带着大家由浅入深，一步一步实现解题过程。你准备好了吗？相信读完本系列文章之后，你会觉得：哇！SQL原来如此简单和有意思。(注：小编用的是...
面试准备：数据库常见面试题汇总
No_Game_No_Life_的博客
04-10 1950
文章目录1.简单解释数据库三范式？2.不满足数据库三范式可能会出现什么情况？3.解释脏读、不可重复读，幻读，更新丢失4. Mysql提供了哪几种事务隔离级别？5. 1.简单解释数据库三范式？ 第一范式就是数据库表的每一列都是不可分割的基本数据项，同一列中不能有多个值。 第二范式要求实体的属性完全依赖于主关键字。所谓完全依赖是指不能存在仅依赖主关键字一部分的属性，如果存在，那么这个属性和主关键字的这...
面试总结SQL 经典面试题
freeRoad
12-02 312
原文： https://www.cnblogs.com/yoyoketang/p/10118924.html 前言 用一条SQL 语句查询xuesheng表每门课都大于80 分的学生姓名，这个是面试考sql的一个非常经典的面试题 having和not in 查询 xuesheng表每门课都大于80 分的学生姓名 name kecheng score 张三 语文 81 张三 数学 73 李四 语文 86 李四 数学 .
数据分析sql面试必会6题经典_SQL面试经典50题：带你从建表开始！
weixin_39528525的博客
12-18 1464
大家好，相信很多学习数据分析的小伙伴在面试前都经历过刷题，本系列小编将带大家一起来刷一刷SQL面试必会的经典50题。当然本系列文章不单单是刷题，小编会带着大家梳理一下解题时用到的知识点，所以基础比较差的小伙伴也完全不必担心，小编会带着大家由浅入深，一步一步实现解题过程。你准备好了吗？相信读完本系列文章之后，你会觉得：哇！SQL原来如此简单和有意思。(注：小编用的是MySQL8.0)一.表的创建和数...
数据分析sql面试必会6题经典_数据分析之SQL面试题
weixin_39902345的博客
12-18 991
作为数据分析师，使用的最多的莫过于SQL语句，这里拿几道典型的SQL面试题为例，学习一下数据库知识。自己搭建MySQL服务器太麻烦，可以使用在线数据库发现sqlzoo是个不错的SQL学习网站【2018-12-19更新】sqlfiddle在线数据库的MySQL版本是5.6，不支持row_number()于是又在电脑上装了最新的MySQL8.0练习1 计算连续登陆天数 关键词 row_number百度...
数据分析sql面试必会6题经典_轻松搞定数据分析之SQL——经典面试题
热门推荐
weixin_35991292的博客
12-30 1万+
你好哇！我猜看到这篇文章并且点进来的你，要么是正在准备数据行业的面试，要么就是未来可能要参加数据行业的面试。嗯……如果猜错了，嘤嘤嘤……求放过！总之，不管什么原因，很高兴遇见你！要说近几年最火的职业之一，肯定少不了数据分析师。正如大部分公司招聘需求上都写着“熟练掌握SQL语言”一样，所有想做数据分析师的求职者简历中，技能一栏一定都写着SQL！学习一门技能，最重要的是最后能不能运用到你的面试和工作当...
MySQL语句面试实例
qq_29423387的博客
10-19 657
参考链接 需要数据库表：（使用phpmyadmin创建） 学生表-Student(SID,Sname,Sage,Ssex) --SID 学生编号,Sname 学生姓名,Sage 出生年月,Ssex 学生性别； 课程表-Course(CID,Cname,TID) --CID --课程编号,Cname 课程名称,TID 教师编号； 教师表-Teacher(TID,Tname) --TID 教师编号,Tname 教师姓名； 成绩表-SC(SID,CID,score) --SID 学生编号,CID 课程编号,sc
有哪些你看了以后大呼过瘾的数据分析书？
data_cola的博客
10-17 829
书不在多，而在于精。我分析了知乎上推荐的数据分析类书籍的回答，最终总结了以下内容，形成了这篇文章。 数据分析类的书有很多，可以按数据分析的流程分类，每个流程应该看哪些书籍。 也可以按照通识类和工具类进行分类，通识类可以理解为入门读物类，工具类就是针对不同的工具必读的书籍了。 还可以按照入门、进阶和高阶进行分类来阅读相应阶段的书籍。 这篇文章我会根据通识类、工具类、应用类三个大分类来总结不得不看的数据分析书籍。也就是从入门到用哪些工具到实战应用三个阶段。 通识类 看了这么多答案，总结了这么多内.
sql语句练习50题(mysql版)
06-06
抱歉，我不能提供具体的 SQL 练习题目。不过我可以提供一些常见的 SQL 查询练习，供您参考： 1. 查询所有的记录 2. 查询指定列的记录 3. 查询指定表中的部分记录 4. 查询不重复的记录 5. 查询按指定列排序的记录 6. 查询指定条件的记录 7. 查询某个字段的最大值和最小值 8. 查询某个字段的平均值 9. 查询某个字段的总和 10. 查询某个字段的记录数 希望对您有所帮助！
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值