DECLARE @TABLE TABLE
(
EmpID CHAR(3)
,Category CHAR(1)
)
INSERT INTO @TABLE VALUES('101','A')
INSERT INTO @TABLE VALUES('102','B')
INSERT INTO @TABLE VALUES('103','C')
INSERT INTO @TABLE VALUES('104','A')
INSERT INTO @TABLE VALUES('105','B')
INSERT INTO @TABLE VALUES('106','C')
INSERT INTO @TABLE VALUES('107','D')
INSERT INTO @TABLE VALUES('108','A')
INSERT INTO @TABLE VALUES('109','A')
INSERT INTO @TABLE VALUES('110','D')
I need to remove record from each duplicated values in [Category] field.
Ex : One record from each A,B,C and D. Any Idea?