Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Location
    mumbai, india
    Posts
    5

    Unanswered: alternative of rownum

    Can any body suggest the alternative of oracle rownum.

    I am using rownum for getting the prerequired number of the row froma query.

    Ex.

    Select * from tab1 where rownum < 3

  2. #2
    Join Date
    Jan 2002
    Posts
    8
    Hi Vijay,

    You could use select * from a fetch first 3 rows only.

    Nilima

Posting Permissions

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