SELECT * FROM ( SELECT ROW_NUMBER() OVER(PARTITION BY parentID ORDER BY parentID ) as Num, * FROM Term WHERE parentID IN (3, 4, 15) )A WHERE Num = 1