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

How to display the records between two range in Oracle SQL Plus?

1101

what is a database? : Sql dba

1101

Enlist the data types that can be used in pl/sql?

1013

How to write html code in pl sql?

1059

what is top in tsql? : Transact sql

1026

What type of database is sql?

979

What is dba in sql? : SQL DBA

999

Explain unique key in sql.

944

Is a foreign key always unique?

884

What is primary key sql?

953

Does sql require a server?

944

Explain exception handling in pl/sql?

990

How many types of index are there?

962

Determine if oracle date is on a weekend?

984

what are integrity rules?

966