How Do I Display Row Number With Records?

1.	How Do I Display Row Number With Records?
Answer» To achive this USE rownum PSEUDOCOLUMN with query, like SQL> select rownum, ename from emp; Output: ----------------- 1 SCOTT 2 Millor 3 Jiyo 4 Smith To achive this use rownum pseudocolumn with query, like SQL> select rownum, ename from emp; Output: ----------------- 1 Scott 2 Millor 3 Jiyo 4 Smith

Answer»

To achive this USE rownum PSEUDOCOLUMN with query, like
SQL> select rownum, ename from emp;

Output:
-----------------
1 SCOTT
2 Millor
3 Jiyo
4 Smith

To achive this use rownum pseudocolumn with query, like
SQL> select rownum, ename from emp;

Output:
-----------------
1 Scott
2 Millor
3 Jiyo
4 Smith

Discussion