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

how many sql ddl commands are supported by 'mysql'? : Sql dba

1028

Define tables and fields in a database

1139

What is constant in pl sql?

1029

what is primary key? : Sql dba

1035

what is 'mysqlimport'? : Sql dba

1061

what are the difference between clustered and a non-clustered index? : Sql dba

1034

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1271

What is an oracle stored procedure?

1058

Does group by remove duplicates?

1048

How many unique keys can a table have?

1020

explain normalization concept? : Sql dba

1053

What is orm in sql?

1052

What will you get by the cursor attribute sql%rowcount?

1044

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1077

What is difference between db2 and sql?

1008