Select Rn, ename From ( Select Rownum rn, Ename &nbs

I have a table .in the table 100 recored is there .we have
get the single row with out using clause..

Question Posted / ajit

Answer Posted / ajit

Select Rn, ename
From ( Select Rownum rn, Ename
From Emp
)
Where Rn = Nth;

Is This Answer Correct ?

1 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is the use of function "module procedure" in pl/sql?

884

Is pl sql and postgresql same?

767

Explain the difference between drop and truncate commands in sql?

738

Does sql require a server?

707

What are commit, rollback, and savepoint?

738

Is clustered index a primary key?

690

What is insert command in sql?

768

What is the purpose of a sql?

688

Is the primary key an index?

763

How do I save the results of sql query in a file?

711

How to find 3rd highest salary of an employee from the employee table in sql?

786

What type of database is sql?

774

What is the command used to fetch first 5 characters of the string?

1093

Explain the insert into statements in sql?

729

Explain what is table in a database?

782