select a.* from(select e.*,rownum sl_no from emp e) a where a.sl

how to retrive only second row from table?

Question Posted / saswati

Answer Posted / saswati

select a.*
from(select e.*,rownum sl_no
from emp e) a
where a.sl_no = 2

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is data control language?

994

What are the operators in sql?

1033

How do I partition in sql?

967

What is java sql connection?

1063

what is denormalization. : Sql dba

1117

what are the performance and scalability characteristics of mysql? : Sql dba

999

What is an emotional trigger?

1006

Explain character-manipulation functions?

1140

What is the importance of sqlcode and sqlerrm?

1356

How do you update a sql procedure?

1032

What are the different ways to optimize a sql query?

949

Explain the components of sql?

1066

Is natural join and inner join same?

931

How do I count duplicates in sql?

1113

what is text? : Sql dba

1075