DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 15

Thread: display the nth row

Threaded View

  1. 05-11-2007, 02:01 AM #1
    jennifer2007
    jennifer2007 is offline Banned
    Join Date
    Feb 2007
    Posts
    212

    display the nth row

    Hi Friends,

    Is there a function in Oracle 10g to display the nth row on a table in the
    default select sequence? Say, if i have 1000 rows in table EMP, I want
    to display the ROWID of the 500th row. In the command "select rownum,rowid from EMP";

    Can you help me please.
    Last edited by jennifer2007; 05-14-2007 at 08:08 PM.
    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

Click Here to Expand Forum to Full Width