sql语句

[jiffer]

用sql语句怎样查询3到8条的纪录。
例如：
sql="select * from jj order by id desc"
怎么写？

[54NB]

select top 3 * from (select top 8 * from jj order by id asc) T desc

[jiffer]

不行呀。

[crazyuu]

看看这个
http://expert.csdn.net/Expert/topic/2898/2898944.xml?temp=.3763391