随笔分类 -  mysql

查询不重复的用户名的最新信息
摘要：1.select tt.* from( select * from comments order by theTime desc) as tt group by newsID2.select * from comments as tt group by id,newsID,comment,theTime havingtheTime=(select max(theTime) from comments where newsID=tt.newsID) 阅读全文
posted @ 2013-05-17 11:25 河边的老牛 阅读(117) 评论(0) 推荐(0)