如person表 pid,sid 两字段 用sid分组,结果如下:
num sid
5 001
10 002
12 003
0 004
select count(*) num,sid from person group by sid
若求有多少组分组,如上例有四组,则
select count(*) from (select count(*) num,sid from person group by sid )
去除重复的项:
select (distinct * ) from table
如person表 pid,sid 两字段 用sid分组,结果如下:
num sid
5 001
10 002
12 003
0 004
select count(*) num,sid from person group by sid
若求有多少组分组,如上例有四组,则
select count(*) from (select count(*) num,sid from person group by sid )
去除重复的项:
select (distinct * ) from table
转载于:https://www.cnblogs.com/danielrocks/p/3386737.html