DISTINCT iş görecektir.

SELECT DISTINCT col1, col2, ...
FROM
(
SELECT col1, col2, ... FROM Media_One.dbo.Video
UNION ALL
SELECT col1, col2, ... FROM Media_Two.dbo.Video
) AS x;

kaynak : https://dba.stackexchange.com/questions/134019/how-would-i-select-distinct-records-from-the-same-table-on-two-different-databas