select distinct CatalogID from table_name order by Addtime
select distinct CatalogID from 表 order by Addtime
select distinct CatalogID,Addtime from table_name order by Addtime
CatalogID要不重复,那你的Addtime是要取最大的还是取最小的?
select CatalogID from 表 group by CatalogID order by max(Addtime)
不可能不能运行,你要把table_name或表换成你自己的表名。
select distinct CatalogID,max(Addtime) as Addtime from table_name order by Addtime
SELECT CatalogID,MAX(Addtime) FROM 表 GROUP BY CatalogID ORDER BY ADDTIME
select distinct CatalogID from YD_Article order by Addtime服务器: 消息 145,级别 15,状态 1,行 1 如果指定了 SELECT DISTINCT,那么 ORDER BY 子句中的项就必须出现在选择列表中。
SELECT CatalogID,MAX(Addtime) FROM 表 GROUP BY CatalogID ORDER BY ADDTIME服务器: 消息 8127,级别 16,状态 1,行 1 列名 'yd_article.Addtime' 在 ORDER BY 子句中无效,因为该列既不包含在聚合函数中,也不包含在 GROUP BY 子句中。
不好意思,应该这样写: select CatalogID, min(Addtime) from table_name group by CatalogID order by min(Addtime)
from 表
order by Addtime
from 表
group by CatalogID
order by max(Addtime)
如果指定了 SELECT DISTINCT,那么 ORDER BY 子句中的项就必须出现在选择列表中。
列名 'yd_article.Addtime' 在 ORDER BY 子句中无效,因为该列既不包含在聚合函数中,也不包含在 GROUP BY 子句中。
select CatalogID, min(Addtime) from table_name
group by CatalogID
order by min(Addtime)
FROM Table_Name
GROUP BY CatalogID
ORDER BY AddTime