1 查询所有数据行和列
SELECT * FROM student02
SELECT SCode, SName, SGrade, SEmail, SSex, SAddress
FROM student02
2 查询部分行或列
SELECT SName, SGrade, SEmail
FROM student02
SELECT SName, SGrade, SEmail
FROM student02
WHERE SName = ‘李四’
选择不是的内容(排除查询)不等于符号!=和<>
SELECT SName, SGrade, SEmail
FROM student02
WHERE SName != ‘李四’
或者
SELECT SName, SGrade, SEmail
FROM student02
WHERE SName <> ‘李四’
3 使用别名
SELECT SName AS 学生姓名, SGrade as 年级, SEmail as 邮件
FROM student02
WHERE SName <> ‘李四’
合并多列为一个新列
SELECT SCode, SName + SEmail AS 姓名邮箱, SGrade, SSex, SAddress
FROM student02
以上红色字体的内容也可以改为 姓名邮箱= SName + SEmail
4 查询空值
SELECT SCode, SName, SGrade, SEmail, SSex, SAddress
FROM student02
WHERE SEmail IS NULL
5 查询中使用常量列
有时候,需要将一些常量的默认信息添加到查询输出中,方便统计或计算。例如,查询学生信息的时候,学校名称统一都是北京新兴桥
SELECT SName AS 姓名, SAddress AS 地址, ‘北京新兴桥’ AS 学校名称
FROM student02
6 查询返回限制的行数
例如查询前两行的数据
SELECT TOP 2 SName AS 姓名, SAddress
FROM student02
另外还可以,提取20%的数据量
SELECT TOP 20 PERCENT SName AS 姓名, SAddress
FROM student02