Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is there any column in DB2 like "ROWNUM" in oracle?

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
0
0
Hi,

I am fetching the details based on ROWNUM in oracle. When I am porting the same query in DB2, the ROWNUM column is not available. Is there any alternative to identify as ROWNUM. Thanks in advance.

bye...
Lakshmi Narayana
 
Sort by date Sort by votes
How about an Oracle like ROWNUM on DB2 for the AS/400? I have tried ROWNUMBER() and it did not recognize it.

Thanks in advance.
Mark
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

P
  • Question
DB2 LUW SYSCATSPACE is full
Replies
0
Views
112
prashant_0701
P
tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
84
tekpr00
tekpr00
gdg1976
  • Locked
  • Question
db2 sql extract double rows (different in case sensitive) 1
Replies
6
Views
97
mikrom
mikrom
handle907
  • Locked
  • Question
ADM10501W - Health indicator "Database Automatic Storage Utilization"
Replies
0
Views
94
handle907
handle907
walter.weinmann
  • Locked
  • Question
Docker Iage IBM Db2 11.5.6.0: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001
Replies
0
Views
102
walter.weinmann
walter.weinmann

Part and Inventory Search

Sponsor

Back
Top