dcsimg
www.webdeveloper.com
Results 1 to 2 of 2

Thread: ORA-00907: missing right parenthesis

  1. #1
    Join Date
    Sep 2012
    Posts
    1

    Post ORA-00907: missing right parenthesis

    Why i'm getting an error like ORA-00907: missing right parenthesis
    in below query?

    SELECT * FROM
    (
    SELECT * FROM
    USER_HISTORY as rounda
    INNER JOIN USER_HISTORY as roundb
    ON rounda.user_login_name=roundb.user_login_name
    AND rounda.updated_on < roundb.updated_on
    ORDER BY updated_on DESC
    )
    as baseview
    GROUP BY user_login_name;

  2. #2
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    19,636
    I don't think Oracle lets you use an ORDER BY within a sub-query. Can you move it outside (to the end of the main query)?
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    eBookworm.us

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this 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
  •  
HTML5 Development Center



Recent Articles