Question

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

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

例如 id, num 5条记录中 有3条num值为1，我只希望筛选出最新的那条。

谢谢

Answer 1

select distinct num,id from 表 order by id desc

Answer 2

distinct order by id desc

Answer 3

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