麻烦帮忙看一下，order by id desc这个语句？

Question

order by id desc这个语句是做什么的？怎么个用法？

Answer 1

应该是order by id desc吧
是sql的命令语句
一般是跟在查询语句末尾的
例如select * from tablename order by id desc
order by 是排序的命令
order by id就是将查询结果根据id的内容升序排列
order by id desc就是将查询结果根据id的内容降序排列

Answer 2

查询出的记录按id倒序排列
select * from 表名 where 条件 orde by id desc