asp 如何实现某字段值相同的只显示一条

选择
姓名
----读取数据库生成上面的格式------

SQL语句写成如下
SELECT id,title,userid
FROM 表名 as a
WHERE userid <> '0' and not exists (select 1 from 表名 as b WHERE b.userid = a.userid and b.id > a.id)
UNION ALL
SELECT id,title,userid
FROM 表名
WHERE userid = '0'
要排序的话，如下
select c.id,c.title,c.userid
FROM
(
SELECT id,title,userid
FROM 表名 as a
WHERE userid <> '0' and not exists (select 1 from 表名 as b WHERE b.userid = a.userid and b.id > a.id)
UNION ALL
SELECT id,title,userid
FROM 表名
WHERE userid = '0'
) as c
order by c.title