in SQL Server

Selecting a row position within a SELECT query