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

How to avoid using cursors?

1176

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1186

what is table? : Sql dba

1109

How do I write a cron which will run a sql query and mail the results to agroup?

1031

How many types of cursors are available in pl/sql?

1165

What is the advantage of nosql?

1113

What are the different types of joins in sql?

1913

What is difference between group by and partition by?

1128

what is union, minus and interact commands? : Sql dba

1254

What is the life of an sql statement?

1076

Does oracle roll back the transaction on an error?

1068

What is a database event trigger?

1211

List and explain the different types of join clauses supported in ansi-standard sql?

1404

How can we find duplicate records in a table?

992

Explain lock escalation? : Transact sql

1268