sql数据库复习.docx

SQL 复****笔记目录 SQL 复****笔记............................................................................................................................. 1 SQL Server 2005 .......................................................................................................................... 3 一. 登陆................................................................................................................................................ 3 ..................................................................................................................................... 4 从课程表中查询所有课程的信息............................................................................................ 4 查询 Course 表中的课程编号, 课程名称, 教师, 上课时间, 限制选课人数和报名人数, 要显示汉字标题......................................................................................................................... 4 消除查询结果的重复性............................................................................................................. 5 返回查询结果的前 n% 行........................................................................................................... 6 在查询结果中增加要显示的字符串........................................................................................ 6 查询学号为 00000001 的学生姓名和班级编号...................................................................... 6 AND( 与),OR (或) ,NOT (非) ................................................................................................. 7 Between …….and 方法(范围限定)或者用 in (a ,b ) ........................................................ 7 查询课程编程不为 004 , 007 , 013 的课程编号和课程名称................................................ 7 Oder by 方法( 放到 where 子句之后) 排序 desc 降序, asc 升序.......................................... 8 模糊查询( Like ) ...................................................................................................................... 8 ..................................................................................................................... 8 1. Sum , Min , Max ,