比如有这样一个表:
id name
1 name1
2 name2
3 name3
sql语句这样:select * from table order by id desc limit 0,2那么取出来的记录是3,2.现在要实现的是取出的是2,3这样顺序的,请问该怎么实现?
id name
1 name1
2 name2
3 name3
sql语句这样:select * from table order by id desc limit 0,2那么取出来的记录是3,2.现在要实现的是取出的是2,3这样顺序的,请问该怎么实现?
select * from table order by id limit 0,2
select * from table order by id ASC limit 1,2
select * from T order by id desc limit 2;