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 heap table? : Sql dba

1045

How do you take the union of two tables in sql?

931

What can sql server reporting services do?

1052

What is cold data?

897

What is a file delimiter?

1011

How many types of tables are there?

899

Why do we need pl sql?

934

What is a Mapplet?

1057

How do you optimize a stored procedure in sql?

892

How to download oracle sql developer?

1055

Explain correlated query work?

989

what is cursor. write example of it. What are the attributes of cursor.

1307

what is rdbms? : Sql dba

958

Is mariadb nosql?

988

what is the syntax for using sql_variant_property? : Transact sql

986