TAG Systems
Wednesday, January 29, 2014
Oracle rownum value increment by two
Oracle sql query you can add rownum to get record number. if you want to get record number one after the other you can use following querry
select rownum,rownum+rownum-1 from emp
it's give the result row number one after the other. emp is sample table name.
ROWNUM
ROWNUM+ROWNUM-1
1
1
2
3
3
5
4
7
5
9
6
11
7
13
8
15
9
17
10
19
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment