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 is 'mysqlimport'? : Sql dba

1019

Write the command to remove all players named sachin from the players table.

1163

what are the differences between char and nchar? : Sql dba

1097

What are few of the schema objects that are created using PL/SQL?

1015

What is left join in sql?

1040

What is varchar used for?

1069

What is pl/sql table? Why is it used?

1014

explain the difference between delete , truncate and drop commands? : Sql dba

1074

What are different methods to trace the pl/sql code?

1094

What are the two parts of design view?

1004

How many types of triggers exist in pl/sql?

1051

What are the different sql languages?

1023

Why do you partition data?

1010

What is embedded sql in db2?

996

what are all the common sql function? : Sql dba

1045