MSSQLserver 查询不重复记录

SELECT * from
table_name as t1
WHERE NOT EXISTS
(SELECT *
FROM table_name as t2
WHERE t1.meeting_id=t2.meeting_id
AND t1.id <> t2.id

)

以上查询table_name中meeting_id不重复的信息。列id为主键不重复。