Results 1 to 2 of 2

Thread: Is there an SQL LIMIT command for SQL Server?

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2000
    Posts
    770

    Is there an SQL LIMIT command for SQL Server?

    Like there is in MySQL?

    I.e. SELECT <fields> FROM <tables> WHERE LIMIT 1

  2. #2
    Frenzied Member Mike Hildner's Avatar
    Join Date
    Jul 2002
    Location
    Des Moines, NM
    Posts
    1,690

    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
  •  



Click Here to Expand Forum to Full Width