select * from (select rownum r1,e.* from emp e) where r1=2;

how to retrive only second row from table?

Question Posted / bindu

Answer Posted / bindu

select * from (select rownum r1,e.* from emp e)
where r1=2;

Is This Answer Correct ?

8 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What are all different types of collation sensitivity?

1042

What is union?

1178

what are date and time intervals? : Sql dba

1065

What is java sql driver?

1129

how to select unique records from a table? : Sql dba

1120

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

1090

How many types of literals are available in pl sql?

1124

What is the location of pre_defined_functions.

1169

How can one get sql*loader to commit only at the end of the load file? : aql loader

1068

What is trigger price?

999

How to run sql functions in pl/sql?

1065

How do I remove sql developer from windows 10?

1122

Is it important to partition hard disk?

1032

Why functions are used in sql?

999

What is a subquery in sql?

1047