Good point, thanks DECLARE @t TABLE( id TINYINT, keyword VARCHAR(20), data VARCHAR(300) ) INSERT INTO @t(id, keyword, data) SELECT 1, 'Pet Store', 'Microsoft SQL Server' UNION ALL SELECT 2, 'SQL Server Database', 'Dinner at a New

0 ), cteb as ( select distinct id, keyword, data, DENSE_RANK() OVER (partition by id order by levels desc) as indexkey from ctea ) select id, keyword, data from cteb where in