求一条去重的SQL语句

[david1128]

ID VOTES GROUP
1 2 武旦组
2 15 老旦组
3 15 老旦组
4 3 花旦组

要求把votes和group都相同数据只选一条出来,(哪条无所谓),效果如下
ID VOTES GROUP
1 2 武旦组
2 15 老旦组
4 3 花旦组



请问用一条SQL怎么做啊

[vc555]

select row_number() over(partition by VOTES,GROUP order by id)
from t
where rownum=1

[vc555]

不是rownum,是：
select * from (
select id,row_number() over(partition by VOTES,GROUP order by id) rn
from t)
where rn=1

[范佩西_11]

select id,votes,GROUP from (select ID ,VOTES , GROUP ,row_number()over(partition by VOTES ,GROUP  order by id) rn from t) where rn=1

[wap21]

不懂，up

[david1128]

row_number() over(partition by VOTES,GROUP order by id) 没怎么用过,试下,谢谢两位啦

[菜谱]

select min(ID),VOTES,GROUP from 表名 group by VOTES,GROUP

[Andy__Huang]

相同记录最小ID
select min(ID) ID, VOTES,GROUP
from tb
group by VOTES,GROUP

相同记录最大ID
select max(ID) ID, VOTES,GROUP
from tb
group by VOTES,GROUP