问一句SQL语句？

[周口店的程序猿]

select distinct userid from(select userid from article order by createdate desc)

这样写是错的？
（ErrorInfo:除非另外还指定了 TOP 或 FOR XML，否则，ORDER BY 子句在视图、内联函数、派生表、子查询和公用表表达式中无效。
）

我的目的是：取文章发布列表的时间倒序排列取唯一的userid列表

[周口店的程序猿]

补充一下我的数据库SQL2005

[worilo]

先坐沙发

[worilo]

distinct不能这么用
试试select distinct userid from(select userid from article order by userid )
或select userid from(select userid from article order by createdate desc)

[qianzongli]

up

[lingar]

select distinct userid from(select userid,createdate from article order by createdate desc)

[周口店的程序猿]

先谢谢各位 呵呵

worilo() 的两句 和我的没区别

已经找到答案
正确SQL如下：
SELECT TOP 10 n, userid FROM (SELECT MAX(createdate) AS n, userid FROM article GROUP BY userid)t ORDER BY n DESC

[iisbocai]

这在sql server中不能用？
在oracle中允许的

[dreamover]

select distinct userid from article order by createdate desc

[lbh198408]

顶一下

[xieshanglian3378]

sql中不是用tab结束的吗 t--- tab
SELECT TOP 10 n, userid FROM (SELECT MAX(createdate) AS n, userid FROM article GROUP BY userid)tab ORDER BY n DESC

[phoenixYiYou]

的确，你写的是Oracle中用的sql语句！呵呵！

[wuxiaodan628]

支持，顶。。。。。。。。。。。。。
学习中。。。。。。。。。。。。。。

[programmebird]

upupup

[xingzhiyun]

select distinct userid from(select top 10000000000 userid from article order by createdate desc) xzy