关于select top 的
创建表格
create table try
(
writer int,
book_name varchar(10),
money int
primary key(writer,book_name)
)

如何使用select top ... 定位记录中的一段记录?????比如的到第5行到第11行之间的5项记录.
补充:如果表格是以一列为主键,可以用select top 6 * from tabl1 where id not in (select top 5 * from table1)
两字段作为主键又怎么样解决呢??高手帮忙!!

------解决方案--------------------
select top 6 * from (
select top 11 * from tabl1 order by writer,book_name
) a
order by writer desc ,book_name desc


------解决方案--------------------
取n到m条记录的语句

1.
select top m * from tablename where id not in (select top n id from tablename)

2.
select top m * into 临时表(或表变量) from tablename order by columnname -- 将top m笔插入
set rowcount n
select * from 表变量 order by columnname desc

3.
select top n * from 
(select top m * from tablename order by columnname) a
order by columnname desc


4.如果tablename里没有其他identity列，那么：
select identity(int) id0,* into #temp from tablename

取n到m条的语句为：
select * from #temp where id0 >=n and id0 <= m

如果你在执行select identity(int) id0,* into #temp from tablename这条语句的时候报错,那是因为你的DB中间的select into/bulkcopy属性没有打开要先执行：
exec sp_dboption 你的DB名字,'select into/bulkcopy',true


5.如果表里有identity属性，那么简单：
select * from tablename where identitycol between n and m 


------解决方案--------------------
sql 2005里面可以用 ROW_NUMBER

SQL code

SELECT *
FROM(
    SELECT rowid = ROW_NUMBER() OVER(ORDER BY writer,book_name), *
    FROM tb
)A
WHERE rowid = 6