SQL单表查询
一、单表查询的语法
select列名1,列名2... from 表名
where 条件
group by field
having 挑选
order by field
limit 限制条数select列名1,列名2... from 表名
select列名1,列名2... from 表名
where 条件
group by field
having 挑选
order by field
limit 限制条数select列名1,列名2... from 表名