1.普通查询
select * from Info #查询Info表中所有内容
select Code,Name from Info #查询Info表中的某几列
2.条件查询
select * from Info where Nation ='n001' #条件查询
select * from Info where Nation ='n001' and Sex = true #条件之间并的关系
select * from Info where Sex = false or Nation = 'n002' #条件之间或者的关系
3.模糊查询(搜索关键字、名称)
select * from ChinaStates where AreaName like '中%' #查询一中开头的
select * from ChinaStates where AreaName like '%城%' #查询包含城的信息
select * from ChinaStates where AreaName like '_城%' #查询城在第二个位置出现的数据
4.排序查询
select * from Car order by Code #desc降序 asc 升序
select * from Car order by Brand
select * from Car order by Brand,Powers #按照两个列排序
关键字 order desc降序 asc 升序
5.统计查询(聚合函数)
select count(Code) from Car #查询总条数 *\Code\1
select max(Price) from Car #查询最大值
select min(Price) from Car #查询最小值
select avg(Price) from Car #查询平均值
select sum(Price) from Car #查询总和
6.分组查询
select Brand,count(*) from Car group by Brand #根据系列分组查看没组的数据条数 Brand 前面可以加任意一组的名并查询
select * from Car group by Brand having count(*) >2 #group 后不可用where只能用 having,查询分组之后数据条数大于2的
7.分页查询
select * from Car limit 0,5 #跳过几条数据取几条数据(N-1)*5