帮忙解决这个筛选问题,有点难咯!!!

[sj396859033]

我的数据表如下:Vote(Voteid,Vnid),在Vote表中数据如下:
a A
b A
a B
b C
d A
d B
e A
f E
g B
h C
我想得到的数据是:取按照字段voteid统计结果(按照奖序排列)的前两名的所有记录,如下:
a A
b A
d A
e A
a B
d B
g B
怕大家不明白,我在说一下我的意图,先取得统计结果:A 4
B 3
C 2
E 1
再根据统计结果,取前两名的所有记录
请问如何实现啊?各位用sql能帮忙写一下吗?谢谢!!!

[lw1a2]

select Vnid,count(Vnid) as cnt into #tmp from Vote group by Vnid
select * from #tmp
select Voteid,Vote.Vnid from Vote where Vote.Vnid in (select Top 2 #tmp.Vnid from #tmp order by cnt)

[lxzm1001]

select * from vote t where voteid in(select top 2 voteid from vote where voteid=t.voteid)

[lxzm1001]

select * from vote t where voteid in(select top 2 voteid from vote where vnid=t.vnid)

[lxzm1001]

刚才有点错误？对不起？现在补上来了

[zhao606]

不知所谓！！不懂斑竹在讲些什么