You want to select the first record in a given set of rows, in MS SQL Server?

Answer 1

Select top 1 * from table name