Question

SELECT * FROM 表名 ORDER BY ID DESC

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

Answer 1

select * from table where id >=10 and id<=15 order by id desc

忘了between ... and ...是否包括边界了。

Answer 2

select * from 表名 where id>9 and id<16 ORDER BY ID DESC