Results 1 to 2 of 2

Thread: SQL Server 7.0 Top Command Convert to Oracle 8i

  1. #1
    Scott Hughes Guest

    SQL Server 7.0 Top Command Convert to Oracle 8i

    I'm trying to convert a simple SQL Statement over to Oracle...

    Select top 25 * from Customers

    Is there a way to just select the top 25 in Oracle??

    Thanks

  2. #2
    krishna Guest

    SQL Server 7.0 Top Command Convert to Oracle 8i (reply)


    You can try out this--
    select * from customers where rownum<26


    ------------
    Scott Hughes at 7/26/00 2:40:26 PM

    I&#39;m trying to convert a simple SQL Statement over to Oracle...

    Select top 25 * from Customers

    Is there a way to just select the top 25 in Oracle??

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •