sql查询时间最近的记录

[lizijun0324]

string strsql = "select post.postid,post.post_title,post.name,post.class,post.time,reply.name,count(replyid) as aaaa from post LEFT outer JOIN reply ON( post.postid=reply.postid) group by post.postid,post.post_title,post.name,post.class,post.time"

各位大虾，这条语句目的是要查询帖子标题，帖子的id，帖子的回复数量，现在我还想查询最后回复人的姓名怎么做啊
表 post
列名postid post_title post name time class
表 reply
列名replyid reply postid time name

[LMAOhuaNL]

根据时间来排序就是了，用order by time desc关键字段比较

[LMAOhuaNL]

selec top 1 数据列 from 表名 order by time desc where 条件

[lizijun0324]

恩，简单的我会，可是要用到我的那个语句里我就不会了，不知道怎么套用，还请高手指点

[子夜__]

string strsql = "select post.postid,post.post_title,post.name,post.class,post.time,reply.name,count(replyid) as aaaa from post LEFT outer JOIN reply ON post.postid=reply.postid group by post.postid,post.post_title,post.name,post.class,post.time order by post.time desc";

[lizijun0324]

貌似有点理解了，感谢这位大虾