Limiting rows in Sql Server

One problem I have always faced with Sql Server (more so, after I used MySql, and saw that MySql allows this) is to find a way to limit the number of rows being fetched in a SELECT query.Although Sql Server provides a ROWCOUNT statement & TOP clause for the SELECT...