Like there is in MySQL?
I.e. SELECT <fields> FROM <tables> WHERE LIMIT 1
Printable View
Like there is in MySQL?
I.e. SELECT <fields> FROM <tables> WHERE LIMIT 1
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.