我想按KK_Topic里的addtime排序取出
KK_Topic中BoardID不同的五条记录,写成这样
select distinct top 5 KK_Topic.BoardID from KK_Topic,KK_Board where KK_Topic.BoardID=KK_Board.BoardID and KK_Board.ParentID=290 order by KK_Topic.addtime desc
出错:ORDER BY 子句与 (KK_Topic.addtime) DISTINCT 冲突。
请问该怎么写::??????????????????
比如说这是topic表
Topicid title boardid addtime
1 abc 100 2007-1-1
2 era 101 2007-1-2
3 avx 102 2007-1-3
4 zcv 100 2007-1-4
5 jhv 100 2007-1-5
6 ztw 103 2007-1-6
7 xcv 102 2007-1-7
8 zww 104 2007-1-8
9 zqw 105 2007-1-9
10 zti 103 2007-1-10
我想取出的是 这样一个记录集
Topicid title boardid addtime
10 zti 103 2007-1-10
9 zqw 105 2007-1-9
8 zww 104 2007-1-8
7 xcv 102 2007-1-7
5 jhv 100 2007-1-5
waiting ol....
------解决方案--------------------
- SQL code
create table topic(Topicid int,title nvarchar(10),boardid int,addtime datetime )insert topic select 1, 'abc', 100, '2007-1-1' union all select 2, 'era', 101, '2007-1-2' union all select 3, 'avx', 102, '2007-1-3' union all select 4, 'zcv', 100, '2007-1-4' union all select 5, 'jhv', 100, '2007-1-5' union all select 6, 'ztw', 103, '2007-1-6' union all select 7, 'xcv', 102, '2007-1-7' union all select 8, 'zww', 104, '2007-1-8' union all select 9, 'zqw', 105, '2007-1-9' union all select 10, 'zti', 103, '2007-1-10' select top 5 boardid from ( select boardid,max(addtime) as addtime from topic group by boardid) tmp order by addtime desc