-
Jan 14th, 2005, 05:56 PM
#1
Thread Starter
Fanatic Member
Is there an SQL LIMIT command for SQL Server?
Like there is in MySQL?
I.e. SELECT <fields> FROM <tables> WHERE LIMIT 1
-
Jan 14th, 2005, 06:41 PM
#2
Frenzied Member
Re: Is there an SQL LIMIT command for SQL Server?
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|