SQL Plus - How do I display row number with records

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Go To First | Previous Question | Next Question

SQL Plus | Question 35 of 132

How do I display row number with records

Total Answers and Comments: 4

Last Update: June 16, 2008

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

March 24, 2005 15:11:46

Ajay

RE: How do I display row number with records

select rownum table_name.* from table_name;

Is this answer useful? Yes | No

March 26, 2005 14:13:04

AjayLebaka

RE: How do I display row number with records

SELECT rownum table_name.* FROM table_name;

Is this answer useful? Yes | No

June 16, 2008 12:06:41

Dr. Codd

Member Since: June 2008 Contribution: 2

RE: How do I display row number with records

SELECT ROWNUM table_name.* FROM table_name;

Is this answer useful? Yes | No

June 16, 2008 23:49:37

sravee123

Member Since: May 2008 Contribution: 24

RE: How do I display row number with records

Select ROWNUM col1 col2 from tablename;

Is this answer useful? Yes | No

User Name		Remember Me?
Password

Question Bank