How can I retrieve first few raws
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How can I retrieve first few raws

  1. #1
    Join Date
    Jan 2001
    Posts
    230

    Question

    Hi:

    How can I retrive the first few (ex. 30) raws from the table in which I don't know the where
    condition.

    Thanks.

  2. #2
    Join Date
    Aug 2000
    Posts
    194
    select * from <table> where rownum <= 30 ;

  3. #3
    Join Date
    Feb 2001
    Posts
    2

    Smile reply

    [QUOTE][i]Originally posted by ora_inf [/i]
    [B]Hi:

    How can I retrive the first few (ex. 30) raws from the table in which I don't know the where
    condition.


    u can use of rownum in query that will give u desire result;

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