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?
 

I found following query. Problem solved. 

DELETE FROM @TABLE
WHERE EmpID IN(SELECT MIN(EmpID) FROM @TABLE GROUP BY Category)