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 company owns postgresql?

1026

Does truncate need commit?

941

What is a field in a database?

1063

Can a table have no primary key?

1057

How do you update sql?

966

What is oracle sql developer?

1043

Explain the methods used to protect source code of pl/sql.

1015

how to analyze tables with 'mysqlcheck'? : Sql dba

1012

What are the different set operators available in sql?

1023

How do you delete data from a table?

1026

What is procedure and function in sql?

997

Is sqlite good enough for production?

992

What is difference between stored procedures and application procedures?

1010

What is identity column in sql server?

1046

What is difference between sql and oracle?

1122