豪门绝恋半路新娘:这条SQL语句怎么把数据都读出来了?

来源:百度文库 编辑:高校问答 时间:2024/04/29 19:10:09
select top 3 [id],[motif],[datetime] from [news] where [sort]=52 order by [datetime] asc
去掉“order by [datetime] asc”竟然就可以了,可我要按时间排序啊,怎么会这样?

后面排序的程序改为order by [datetime] desc,如果没有desc的话,系统默认是升序排序,有desc就是按时间的降序排序

asc to desc? try again.