SELETC [ALL | DISTINCT]
{*| table.* | [table.field1[ as alist1] [,table.filed2 [as alist2]][,...]] }
FROM table_name [as table_alias]
[left| out |inner join table_name2] #联合查询
[ where...] #制定结果需满足的条件
[GROUP BY...] #指定结果按照哪几个字段来分组
[HAVING...] #过滤分组的纪录必须满足的次要条件
[ORDER BY...] #指定查询记录按一个或者多个条件排序
[LIMIT{ [ oppest,]row_count |row_count OFFSET offset }]; #指定查询的记录从哪条至哪条