Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2014
    Posts
    1

    Thumbs up Unanswered: How to Select row id in DB2

    Hi All,

    I have one clarification. In Table how to select row id.

    I have used the below query to select row id but its not display row id.

    An implicitly hidden ROWID column is called a hidden ROWID column.

    SELECT ROW_NUMBER, COLU1 FROM TABLE-NAME

    SELECT row_number(), first_name FROM beatles

    Thanks,
    Madhavan

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Oracle provides it as a pseudocolumn; db2 does NOT provide rowid.

    BTW: did you try to Google it?
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Posting Permissions

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