以文本方式查看主题 -  课外天地 李树青  (http://www.njcie.com/bbs/index.asp) --  数据库系统原理课件  (http://www.njcie.com/bbs/list.asp?boardid=19) ----  关于SQL Server中一些SELECT语句的练习  (http://www.njcie.com/bbs/dispbbs.asp?boardid=19&id=150)

--  作者：admin --  发布时间：2006/3/27 21:05:18 --  关于SQL Server中一些SELECT语句的练习 1、查看学生的姓氏情况 select distinct substring(name,1,1) from stu 2、运行多个查询语句 注意：go此时可以省略 select * from stu go select * from grade go 3、选取集合数据 select * from stu where name in (\'黎明\',\'刘英\') 4、识别空值 select * from stu where name is not null 5、匹配符 select name from stu where name like \'刘X%\' escape \'X\' 6、虚拟列 select name as \'姓名\',round(height*100,1,0) as \'身高\',\'CM\' as \'单位\' from stu 7、注释 /* 这是注释 这是注释 */ select * from stu--这是注释 8、日期函数处理 select year(birthday),month(birthday),day(birthday) from stu where birthday=\'1976-07-01\' 9、暂存表 select * into tempstu from stu 10、多表查询 select name ,cid,grade from stu,grade where stu.number=grade.number select name ,cid,grade from stu inner join grade on stu.number=grade.number select name ,cid,grade from stu left outer join grade on stu.number=grade.number 查询谁没有选修课程 select name from stu left outer join grade on stu.number=grade.number where cid is null 11、查询每个人的最小成绩 select name ,min(grade) from stu,grade where stu.number=grade.number group by stu.name 利用“与主查询有关的子查询” select name,grade from stu ,grade where stu.number=grade.number and grade=(select min(grade) from grade where grade.number=stu.number) [此贴子已经被作者于2006-3-27 21:07:45编辑过]