Question

[asp]关于order by两个条件的语句

如果按点击数同时时间条件来排序,如何写语句
order by click desc?

Answer 1

order by 点击数,时间

如果是倒序的话后面加desc

order by 点击数 desc

Answer 2

select * from form1 order by (select * from form1 order by date desc) desc
你大概就是想要这样的结果吧?

Answer 3

order by 时间字段名 desc或order by 时间字段名 asc