Hi

I would use GROUP BY and MIN.

DECLARE @t TABLE (GroupId INT, Subgroup INT)

INSERT INTO @t

SELECT 1, 11

UNION ALL SELECT 1, 12

UNION ALL SELECT 1, 13

UNION ALL SELECT 2, 21

UNION ALL SELECT 2, 22

UNION ALL SELECT 2, 23

UNION ALL SELECT 3, 31

UNION ALL SELECT 3, 32

SELECT

GroupId,

MIN(Subgroup)

FROM @t

GROUP BY GroupId

Greets

Flo