Where can I read about how to limit the numbers...

• ivanrdgz

  Old Hand

  Points: 304

  More actions

  July 10, 2003 at 2:41 pm

  #106337

  of rows resturned by a query?

  In other words, something similar to the MySQL's LIMIT option

  Thanks

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  July 10, 2003 at 3:19 pm

  #464979

  SET ROWCOUNT your_number_of_row.

  causes SQL Server to stop processing the query after the specified number of rows are returned.

  or

  Using TOP and PERCENT to limit the number of rows returned in the result set.