Select Top 1 or Top n basically returns the first n rows of data based on the SQL query. Select Top 1 1 or Top n s will return the first n rows with data s depending on the SQL query.
Example: Top 10
1)SELECT TOP 10 FirstName, LastName
FROM [tblUser]
where EmailAddress like 'john%'
2) SELECT TOP 10 'test'
FROM [tblUser]
where EmailAddress like 'john%'
A second will be given the same output as first but the values will be a test