ASP 循环数据某数字字段有多个相同值只取最后一条 怎么写?谢谢

2025-01-08 05:55:58
推荐回答(3个)
回答1:

select distinct num,id from 表 order by id desc

回答2:

distinct order by id desc

回答3:

select top 1 distinct num,id from table order by id desc