Results 1 to 2 of 2

Thread: select top

  1. #1
    Join Date
    Jan 2004
    Posts
    40

    Unanswered: select top

    i want to select the top 3 records, and i'm doing it like so...

    select * from (select col1 from table1 order by col2) where rownum < 4

    this works in oracle 8, but in oracle 7, it says missing right parenthes

    does anyone know the problem?

    my guess is oracle 7 doesn't allow order by in the sub query. If that is the case, is there an alternate solution to select top?

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: select top

    In Oracle 7 I think you would have to use a cursor.

Posting Permissions

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