How to get first and last record in sql

To get first and last record in sql write the followig query.

select * from dbo.Communities where Community_ID in(select min(Community_ID) from dbo.Communities union select MAX(Community_ID)from dbo.Communities)