Question

SELECT * FROM 表名 ORDER BY ID DESC

SELECT * FROM 表名 ORDER BY ID DESC如果我表中ID为1-20，我想调10-15的5条记录降序显示，怎么写呢？？？

Answer 1

楼上的SQL针对编号固定,如果ID不固定 就不正确了 select top 5 * from table where id not in (select top 10 id from table) //查出前5条数据 并且这5条数据不属于前10条数据内 也就是11-15select top 5 * from table where id not in (select top 5 id from table ORDER BY ID DESC) ORDER BY ID DESC//查出后5条数据 并且不在后5条数据内 20条数据 查出来的也是11-152个TOP的数字动态变更就是一个翻页效果使用的SQL了

Answer 2

看你是什么数据库了 如果是access的话就是楼上写的select * from 表名 where id between 10 and 15 order by id desc如果是mysql数据库的话select * from 表名 order by id desc limit 10,15

Answer 3

select * from 表名 where id between 10 and 15 order by id desc

Answer 4

SELECT fID FROM cart ORDER BY fID DESC LIMIT 1