Question

sql 语句 distinct 多列显示问题

select distinct orderid from orderlist where uid='2' order by id desc

这条会报错，
我想显示orderid 列数据，但是要按ID列绛序排列

我在线等
select distinct orderid from (select top 100 orderid from orderlist where uid='2' order by id desc)

写了top 100 还有错误
第 1 行: ')' 附近有语法错误。

Answer 1

select distinct orderid from (select orderid from orderlist where uid='2' order by id desc)

这个求出 oraderid 的按照 ide 倒序 的集合
select orderid from orderlist where uid='2' order by id desc
然后 求 distinct

Answer 2

select distinct orderid,id from orderlist where uid='2' order by id desc

Answer 3

select distinct B.orderid from (select top 1000 orderid from orderlist where uid='2' order by id desc) B

Answer 4

select orderid from (select orderid ,id,row_number() over (partition by orderid order by id desc) rn
from orderlist where uid='2'
) aa
where rn=1 order by id desc;