>>< snip >
>>>
>>>It'd be nice if SELECT FIRST 10 would be supported as well as SELECT LAST 10.
>>
>>Isn't SELECT TOP 10 the same as SELECT FIRST 10 ?
>
>Yes, I was mostly making reference to the SQL Server syntax.
>
>I had the assumption that the SQL syntax, supported on SQL Server, was grabbing the first records which were meeting the condition without having to select from the entire table first.

Yes, you are right. In SQL Server it works the way you discribed if there is no Order By clause.