no sex country age 1 M china 12
2 M china 12
3 F china 13
4 M china 12
5 F china 13把sex country age 同时相同的取出来放在一个新表中,
如:
sex country age
M china 12
F china 13
2 M china 12
3 F china 13
4 M china 12
5 F china 13把sex country age 同时相同的取出来放在一个新表中,
如:
sex country age
M china 12
F china 13
select sex,country,age from tablename
group by sex,country,age
inset into 新表
select sex,country,age from tablename
group by sex,country,age
绝对可行!
select distinct sex,country,age from tablename
我顶!!赞同!
如下:
no sex country age 1 M china 12
2 M china 12
3 F china 13
4 M china 12
5 F china 13把sex country age 同时相同的取出来放在一个新表中,
如:
sex country age count
M china 12 3
F china 13 2
into 新表
from tablename
select distinct sex,country,age from tablename