Top

SELECT TOP 100 <COLUMN>
FROM <TABLE>

Selects the first 100 records from <TABLE> that meet all the criteria but starting from the top of the table scan. it's the first encountered valid records