直接上代码
select name,sex from
(select id,name,sex from person order by age limit 0,999) as newPerson
group by sex
limit:一定要加。从第0行到最大行
实现了分组内排序,根据自己实际的需求对例子进行改动即可
直接上代码
select name,sex from
(select id,name,sex from person order by age limit 0,999) as newPerson
group by sex
limit:一定要加。从第0行到最大行
实现了分组内排序,根据自己实际的需求对例子进行改动即可