I am trying to create a query that will return the first matching record for each GlobalId from in a list. In the table I usually have more than one record per GlobalID but only need to pull back the first record encountered per GlobalID match.
I have tried using TOP but it returns all records related to each global id as my query below is currently written.
SELECT TOP 25 *
FROM [Reconciliation-Working Copy]
WHERE GlobalID IN (SELECT Distinct GlobalId FROM [Reconciliation-Working Copy] WHERE GlobalID <> 'NULL')