![](https://i-blog.csdnimg.cn/blog_migrate/8f900a89c6347c561fdf2122f13be562.gif)
![ExpandedBlockStart.gif](https://i-blog.csdnimg.cn/blog_migrate/961ddebeb323a10fe0623af514929fc1.gif)
select
*
from
LYHG_News_Message,(
select
NewsID,
max
(Insert_time)
as
maxTime
from
LYHG_News_Message
group
by
newsID)
as
maxTimeMsg
where maxTimeMsg.newsID = LYHG_News_Message.newsID and maxTimeMsg.maxtime = LYHG_News_Message.insert_time
where maxTimeMsg.newsID = LYHG_News_Message.newsID and maxTimeMsg.maxtime = LYHG_News_Message.insert_time