每个类别提取最新一条记录
摘要:
每个类别提取最新一条记录SELECT id,title,news_int from news as T where ID IN(SELECT TOP 1 ID FROM news WHERE s_id=T.s_id ORDER BY id DESC) 阅读全文
posted @ 2009-11-14 17:49 simen 阅读(231) 评论(0) 推荐(0) 编辑
posted @ 2009-11-14 17:49 simen 阅读(231) 评论(0) 推荐(0) 编辑