帮忙改一下分页语句，非常的急

Question

SELECT TOP 10 StarName from StarMusic
 WHERE id not in 
(select top 50 id from StarMusic WHERE starname in(
select  starname from starmusic where len(Mp3Num)>6 group by StarName ) order by StarName )
  AND len(Mp3Num)>6  
group by StarName order by StarName

Answer 1

SELECT TOP 10 StarName 
   from StarMusic 
      WHERE id not in (
                        select top 50 id 
                           from StarMusic t
                              WHERE len(Mp3Num)>6 
                                    and
                                    not exists(select 1 
                                                 from StarMusic
                                                   where StarName=t.StarName
                                                         and
                                                         id<t.id
                                              )
                              order by StarName 
                      )  
            AND 
            len(Mp3Num)>6  
      group by StarName 
      order by StarName

Answer 2

id和StarName是什么关系？一对多？

Answer 3

没有关系，ID无重复，StarName有重复

Answer 4

实际上是想让
select StarName from starmusic where len(Mp3Num)>6 group by StarName order by StarName
列出的数据能分页显示，每页10条StarMusic表里有id  StarName  MusicName Mp3Num      id无重复，StarName有重复

Answer 5

select StarName from starmusic where len(Mp3Num)>6 group by StarName order by StarName
太复杂了吧，改成
select distinct from starmusic where len(Mp3Num)>6 order by StarName

Answer 6

declare @page int --页数
set @page=1SELECT *
   from StarMusic t
      WHERE (select count(1) 
               from StarMusic 
                  where id<=t.id
            ) 
         between (@page-1)*10+1 
            and (@page-1)*10+11
order by id