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 row_number () in sql?

947

What is pl sql variable?

956

what are dynamic queries in t-sql? : Transact sql

984

Explain the difference between drop and truncate commands in sql?

991

What is asqueryable?

915

how to use 'mysql' to run sql statements? : Sql dba

1010

Why do we need view in sql?

951

Is postgresql a server?

1013

What are the different type of joins in sql?

921

What can I use instead of union in sql?

925

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

960

Which join condition can be specified using on clause?

916

Can one improve the performance of sql*loader? : aql loader

997

What are the built in functions of sql?

999

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1401