select * from table1 t where t.id in (select top2 id from table1 where name=t.name)
這個查詢語句是什麼意思呢？