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