Y>    (select top 100
Y>        rowid   as r1,
Y>        id as id1,
Y>        text as text1,
Y>        comment as comment1
Y>    from dbo.test_table
Y>    where rowid in (select max(rowid) from dbo.test_table group by id)) A
Y>

where rowid not in ...