Question

用SQL语句怎样对字段里的内容按指定顺序排列?

以下是一个论坛程序里的其中一个表:
我bbs表里有有一个字段paixu,字段里的内容有"普通"和"精华",我想编写代码,把精华的帖子都放在前面,sql 语句该怎么写呢?

Answer 1

就是order by吧？指定一个列，asc或者desc正序逆序而已

Answer 2

select 帖子名称 from bbs group by paixu order by paixu desc

Answer 3

select * from bbs order by paixu asc
select * from bbs order by paixu desc

Answer 4

您好，下面的这条语句可以解决您的问题吗？
select * from table_bbs order by paixu desc

Answer 5

select * from bbs group by paixu order by paixu