可是name,creatdate字段的数据也不相同,要保留吗?
如果不需要保留以上两个字段,在order by前增加个group by
SELECT DISTINCT
board.boardname, board.re, board.id, max(Title.creatdate) creatdate
FROM board INNER JOIN
Title ON board.id = Title.boardid INNER JOIN
retitle ON Title.id = retitle.titleid
group by board.boardname, board.re, board.id
ORDER BY board.id
如果不需要保留以上两个字段,在order by前增加个group by
SELECT DISTINCT
board.boardname, board.re, board.id, max(Title.creatdate) creatdate
FROM board INNER JOIN
Title ON board.id = Title.boardid INNER JOIN
retitle ON Title.id = retitle.titleid
group by board.boardname, board.re, board.id
ORDER BY board.id
解决方案 »
- WinForm 获取项目路径
- web调用OCX控件的初始化方法,需要父窗口句柄?
- 无法添加该列,原因是它的cellType属性为空 异常求助!
- 各位贤才,IIS不能浏览asp.net 文件怎么回事?
- 求 vs 2005 的MSDN下载!!!!!!!!!!
- 关于Datagridview中的修改问题
- 谁研究NHibernate亚,看了1周了没有头绪,从何看起?如何研究这个系统?已经看了张老三的文章,看不懂!
- 非常着急,谢谢那位大侠现在提供源码参考,200分相送
- 移动企信通 SMEIDLL.dll 调用问题求助
- 线程问题
- 一个关于结构体嵌套的问题?
- 到底什么叫做面向对象?自认为搞清楚了,可是经理说我没搞清楚。(之二)
boardname re id name creatdate num
技术交流 交流心得。。 1 11 2008-3-3 8:30:30 2
提问专区 全新的 2 33 2008-3-3 8:20:30 1
图形图像 灵感天堂。。 3 44 2008-4-3 8:20:30 2
美化专区 不同界面。。 6 66 2008-4-4 8:20:00 3
这里的num怎么样让他出来
谢谢了
board.boardname, board.re, board.id, max(Title.creatdate) creatdate,count(board.id) num
FROM board INNER JOIN
Title ON board.id = Title.boardid INNER JOIN
retitle ON Title.id = retitle.titleid
group by board.boardname, board.re, board.id
ORDER BY board.id
(
SELECT DISTINCT
board.boardname, board.re, board.id, Title.name, Title.creatdate
FROM board INNER JOIN
Title ON board.id = Title.boardid INNER JOIN
retitle ON Title.id = retitle.titleid
ORDER BY board.id
) a
group by a.boardname, a.re, a.id