T-SQL UNION query to return items with highest and lowest rating from the same table

Question

I want write a stored proc in T-SQL to return the top 5 most highly rated and the bottom 5 most lowly rated articles from an Articles table, determined by the 'rating' column.

I was thinking of using a union on two selects but I'm not sure how to write it.

Answer 1

select * from (select top 5 *, 'Bottom Five' as Ranking from Call order by id ) a
union all
select * from (select top 5 *, 'Top Five' as Ranking from Call order by id desc ) b