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 meant by cursor in sql?

985

List out the acid properties and explain?

949

What are the ddl commands?

1005

Is time a data type in sql?

901

how to load data files into tables with 'mysqlimport'? : Sql dba

1091

What if we write return in procedure?

1420

what is an index? : Sql dba

987

What is Histogram?

1554

What is acid property in a database?

1031

What is rank dense_rank and partition in sql?

1026

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1162

Does mysql_real_escape_string prevent sql injection?

944

Which normal form is best?

948

Can we edit a view in sql?

981

What problem one might face while writing log information to a data-base table in pl/sql?

1155