sql语句问题

显示全部楼层 · 2007-1-24 10:54:18

use northwind select * from ( select top 5 * from ( select top 10 * from 表名 order by new_sj desc ) as t1 order by new_sj asc ) as t2 order by new_sj desc

千问 · 2007-1-24 10:54:18

SELECT TOP6* FROM 表名 WHERE
(
主键名 NOT IN(
SELECT TOP4 主键名
FROM 表名
order by 主键名)
) order by 主键名

千问 · 2007-1-24 10:54:18

你这第5-10条记录，是按什么排的，是按照表里的正常显示顺序从头数第5-10条记录吗

千问 · 2007-1-24 10:54:18

select top 10 * from A where id not in(select top 5 id from A order by new_sj) order by new_sj

千问 · 2007-1-24 10:54:18

SELECT * FROM xxxWHERE yyy BETWEEN 5 AND 20order by new_sj;注：xxx表名。yyy你所指的第几点如何排，一般应为主键。建表是一般使用rid或pid