SQL？Server单表数据查询举例详解（sql单表查询和多表查询哪个好）干货满满

目录一、向SQL Server中导入数据二、例题1.查询所有学生的全部信息2.查询学生的学号和姓名3.查询所有学生的姓名和出生年4. 查询所有学生的姓名和出生年，要求列名是汉字形式5.查询CS系的所有学生信息6.查询CS系的所有男同学信息7.查询年龄在18到20之间的学生信息8.查询年龄不在18到20之间的学生信息9.查询所在系为CS和JD的学生信息10.查询姓张的学生的信息11.查询姓名只有两个字且姓李的学生的学号和姓名12.查询没有成绩的学生的学号和课程号13.消除重复行：查看CS系的年龄情况14.查询前三个同学的信息15.统计男学生人数16.统计sc表中选修过课程的学生人数（注意要去掉重复选课的学生的学号）17.从表sc中查询所有成绩中的最高分和最低分18.统计学号为1204304102的学生的总成绩和平均成绩三、小结(1) 有三种方法可以指定列名(2)根据名字的信息查询题目类总结(3)查询知识拓展总结

SELECT * FROM student

SELECT sno,sname FROM student

SELECT sname,YEAR(GETDATE())-sageFROM student

SELECT sname 姓名,YEAR(GETDATE())-sage 出生年FROM student

select * FROM student WHERE sdept=’CS’

select * FROM student WHERE sdept=’CS’ AND ssex=’男’

select * from student where sage>=18 and sage<=20

select * from student where sage BETWEEN ’18’ AND ’20’

select * from student where sage<18 or sage>20

select * from student where sage not BETWEEN ’18’ AND ’20’

select * from student where sdept=’CS’ or sdept=’JD’

select * from student where sdept in(‘CS’,’JD’)

select * from student where sname like’张%’

select sno,sname from student WHERE sname LIKE ‘李_’;

select * from sc WHERE grade IS NULL;

select DISTINCT sage FROM student WHERE sdept=’cs’

select TOP 3 * from student

select COUNT(sno) 男生人数 from student where ssex=’男’

select COUNT(*) AS 男生人数 from student where ssex=’男’

select COUNT(distinct sno) from sc

select max(grade) 最高分,MIN(grade) 最低分 from sc

select SUM(grade) 总分,AVG(grade) 平均分 from sc where sno=’1204304102′

select sname 姓名,YEAR(GETDATE())-sage as 出生年,院系=sdept from student

select * from student where sname like’张%’

select * from student where sname like’黄_’

select * from student where sname like’_文_’

select TOP 3 * from student

select grade from sc where cno=’2102′ order by grade desc

select TOP 2 grade from sc where cno=’2102′ order by grade desc

您可能感兴趣的文章:sqlserver 树形结构查询单表实例代码