select小结

select 完整语法

select [all | distinct]
{ * | table.* [[ table.filed1 ][ as alias1][, table.filed2[ as alias2]][ ... ]]}
from table_name [ as table_alias]
	[ left | right | inner join table_name2] -- 联合查询
	[ where ... ]    --查询结果满足的条件
	[ group by ... ]  -- 指定结果按照哪几个字段来分组
	[ having ... ]    -- 过滤分组的记录必须满足的次要条件
	[ order by ...]   -- 指定查询记录按一个或者多个条件排序
	[ limit startIndex,pagesize]  -- 只当记录起始位置和页面大小

注意：[ ]括号的内容代表可选，{ }括号内容代表必填