Results 1 to 2 of 2

Thread: Query.

  1. 07-21-2000, 09:55 AM #1
    ravi Guest

    Query.

    Is there any way we can limit the number of rows returnd from a query in SQL Server?
    Like in Oracle we may write rownum<5.
    Reply With Quote Reply With Quote
  2. 07-21-2000, 10:43 AM #2
    Ray Miao Guest

    Query. (reply)

    Use &#39;set rowcount n&#39;.


    ------------
    ravi at 7/21/00 10:55:54 AM

    Is there any way we can limit the number of rows returnd from a query in SQL Server?
    Like in Oracle we may write rownum<5.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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