WITH orders AS(
SELECT MAX(a.CreateTime) CreateTime,c.NewsTypeID
FROM NewsType_NewsMainPage_ERP c
INNER JOIN NewsMainPage a
ON a.NewsMainPageID = c.NewsMainPageID
GROUP BY c.NewsTypeID
)
SELECT a.NewsTitle,d.CreateTime,b.NewsTypeName
FROM NewsType_NewsMainPage_ERP c
INNER JOIN NewsType b
ON b.NewsTypeID = c.NewsTypeID
INNER JOIN NewsMainPage a
ON a.NewsMainPageID = c.NewsMainPageID,
orders d INNER JOIN NewsType e
ON d.NewsTypeID = e.NewsTypeID
WHERE d.CreateTime = a.CreateTime
select * From NewsMainPage where CreateTime=(select max(CreateTime) From NewsMainPage)
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024