oracle中group by 和order by同时存在时 关键点:order by 的栏位必须在group by 中有;例如:select name from TABLE group by name ,id order by id asc