sql group by 排序问题

发布网友发布时间：2022-05-24 07:15

共5个回答

热心网友时间：2023-10-08 16:41

你的这个语句有点问题，如果只想要任务号，其实不用Group by，只需要
select distinct [任务号] from 记录_V where 记录_V.[任务号] is not null order by [任务号] desc
就可以了，之所以group by，是要做聚合用的，你这个语句好像没有任何聚合

热心网友时间：2023-10-08 16:41

string sqlstr = "select [任务号] from 记录_V where 记录_V.[任务号] is not null group by [任务号] order by [发酵任务号] desc "

热心网友时间：2023-10-08 16:42

string sqlstr = "select [任务号] from 记录_V where 记录_V.[任务号] is not null group by [任务号] order by [发酵任务号] DESC";

后面加DESC

热心网友时间：2023-10-08 16:43

group
by
是分组。

热心网友时间：2023-10-08 16:43

这样写：
select
*
form
bookcontent,(select
book_id_a,addtime_a=max(addtime)
from
bookcontent
group
by
book_id)a
where
book_id_a=book_id,addtime_a=addtime)