Това дали ще свърши работа?

SELECT t.name, *
FROM temp AS t
WHERE (((t.id) In (select top 2 ID from [temp] tt where tt.section_id = t.section_id order by tt.name asc )))
ORDER BY t.section_id, t.name;