oracle中group by 和order by 同时用

Question

oracle中group by 和order by 同时用

Answer 1

oracle中group by 和order by 同时用select name from A group by name ,id order by id asc order by 的栏位必须在groupby 中有