Results 1 to 3 of 3

Thread: How to retrieve top 10 records from ORACE Table

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 04-24-2007 #1
    ppooven
    ppooven is offline
    Junior Member
    Join Date
    Feb 2007
    Answers
    2

    How to retrieve top 10 records from ORACE Table

    How to retrieve top 10 records from ORACE Table

    Reply With Quote Reply With Quote
  2. 04-24-2007 #2
    ppooven
    ppooven is offline
    Junior Member
    Join Date
    Feb 2007
    Answers
    2

    Re: How to retrieve top 10 records from ORACE Table

    SELECT *
    FROM (select * from suppliers ORDER BY supplier_name) suppliers2
    WHERE rownum <= 10
    ORDER BY rownum;

    Reply With Quote Reply With Quote
  3. 07-12-2007 #3
    debasisdas
    debasisdas is offline
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074
    Send a message via ICQ to debasisdas Send a message via AIM to debasisdas How to retrieve top 10 records from ORACE Table

    Re: How to retrieve top 10 records from ORACE Table

    select * from table_name where rownum <11;

    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

About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
GeekInterview
Interact