Is there an SQL LIMIT command for SQL Server?

[Mike Hildner]

Sql Server has the TOP keyword, as in SELECT TOP 100 col1, col2... or SELECT TOP 42% col1, col2... I don't *think* there's any equivilent to MySql's ...LIMIT 20,30, but you can achieve the same results differently by using NOT IN.