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 mysql optimizes distinct? : Sql dba

561

What is gpt format?

515

Why functions are used in sql?

527

What is the difference between function and procedure in pl/sql?

559

Write a sql query to convert all character to uppercase after hypen.

973

How do you update a table in sql?

524

What is null in pl/sql?

632

Why sql query is slow?

583

Is hadoop a nosql?

585

What is insert command in sql?

533

What is number function in sql?

539

What are the rules to be applied to nulls whilst doing comparisons?

765

What is the use of partition by in sql?

527

what does it mean to have quoted_identifier on? : Sql dba

685

How can you save or place your msg in a table?

530