Question

mysql 的order by 和limit 一起怎么用？ - 技术问答

我是这样写的select * from order by uid limit 10,5;不过貌似有问题！！！

Answer 1

select * from sometable order by id desc limit 0,5

Answer 2

select * from table where id='id' order by time DESC limit 0,5;

Answer 3

select * from yourTableName order by uid limit 10,5

Answer 4

那我要是取其中的某几条，还得算一算！！！

Answer 5

你没写表名