求SQL语句

[qugui]

我要做一个根据点击排行的表。
我的语句是这样的：
select movieHit,movieName,movieID from movieT where movieHit in (select top 10 movieHit from movieT)
但现在有问题，movieHit在表中有重复，这样10个最高的movieHit返回的值不止10条，
我的语句要怎么写才能只返回10条movieHit最高的记录.

[glacier111]

select movieHit,movieName,movieID from movieT where movieHit in (select distinct top 10 movieHit from movieT)

[qugui]

这样可能行不通，movieHit 在 (select distinct top 10 movieHit from movieT)记录中会找到不止10条的记录，因为movieHit不是唯一的。

[zty0527]

drop table a
create table a
(
[id] int,
[movieHit] int
)
go

insert into a select 1,10
union all
select 2,10
union all
select 3,1
union all
select 4,9
union all
select 5,8
union all
select 6,7
union all
select 7,6
union all
select 8,5
union all
select 9,4
union all
select 10,3
union all
select 11,2
union all
select 12,9




select [id],[movieHit] from (select distinct top 10 [id],[movieHit] from a ) as b

[zty0527]

1 10
2 10
3 1
4 9
5 8
6 7
7 6
8 5
9 4
10 3

[zty0527]

改成这样select [id],[movieHit] from (select distinct top 10 [id],[movieHit] from a order by moviehit) as b

[lazyfish]

select top 10 movieHit,movieName,movieID from movieT order by movieHit desc

[zty0527]

3 1
11 2
10 3
9 4
8 5
7 6
6 7
5 8
4 9
12 9

[teachman_999]

select top 10 movieHit,movieName,movieID from movieT order by movieHit desc