搜索数据时如何进行数据排序？

[ckxp]

select distinct(action) from abc order by id desc
他就会提示distinct 与order by 发生冲突。去掉order by就正常了。

我的目的是想搜索出不重复的数据，重复的数据就不显视了。然后将搜索出的不重复数据按ID排序。

[annkie]

select distinct action from abc order by id desc

[wscqstu]

select distinct(action),id from abc order by id desc
這樣就可以了

[cmsoft]

select distinct action,id from abc order by id desc

[叶子哟]

结果集中必须有order by 的东东！