T-SQL 查询语句结构
select 列名
from 表名
[where 查询条件]
[group by 分组]
[having 分组条件]
[order by 排序]
语法:
select 列名,列名,列名... 或 *(代表所有) from 表名
例如:
select * from Student
语法:
select 列,列 或 * (代表所有列) from 表名
[where <查询条件>]
例如:
select * from Student
where Sex='男'
语法:
select 列,列 或 * (代表所有列)
from 表名
[where <查询条件>]
[order by 列名 排序类型] 排序类型默认值(asc),asc升序, desc降序
例如:
select * from Student
where Sex='男'
order by avg desc,Grade asc
例如:
select * from Student
where Email is null or Email=''
语法:
select 列,列 或 * (代表所有列) from 表名
[where <查询条件> like '条件']
例如:
select * from Student
where Address like '%河北%'
语法:
select 聚合函数,字段 from Student
group by 字段
例如:
select count(*) AS 人数,GradeId AS 年级 from Student
group by GradeId
语法:
select 聚合函数,字段 from Student
group by 字段
having 聚合函数条件
例如:
select count(*) AS 人数,GradeId AS 年级 from Student
where sex='男'
group by GradeId
having count(*)>15