1、查询指定列
SELECT classNo,className,institute
FROM class
SELECT DISTINCT institute
FROM class
SELECT *
FROM class
4、给属性列取名
SELECT institute 所属学院,classNo 班级编号,className 班级名称
FROM class
SELECT institute AS 所属学院,classNo AS 班级编号,className AS 班级名称
FROM class
SELECT courseNo 课程号,LOWER(courseName) 课程名,courseHour/16 AS 周课时
FROM Course