求一个SQL语句

[php_aga]

table name :TEST
ID NUM
1 3
1 4
2 5
3 6
7 9
3 8

请问如何一个语句查询出同一ID有1个以上的NUM值

[rucypli]

select id from test group by id having count(distinct num)>1

[ACMAIN_CHM]

select *
from test 
where id in (select id from TEST group by id having count(*)>1)

[zalvsa]

select id,count(distinct num) from test group by id

[Gary-chen]

select id from test group by by having count(num)>1

[QQHRSWB]

select *
from test
where id in (select id from TEST group by id having count(*)>1)
正解

[GIS_Cloud]

跟前面那个基本一样，楼上正解