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

Which command is used to call a stored procedure?

499

how does a local variable is defined using t-sql? : Transact sql

539

what is query cache in mysql? : Sql dba

575

How to convert comma separated string to array in pl/sql?

596

Does sap use sql?

513

Why stored procedure is faster than query?

515

What pl/sql package consists of?

636

What is cold data?

503

What is a sql profiler?

590

Does oracle use sql?

512

What is a sql driver?

525

How to handle bulk data?

889

Is sql a dbms?

530

How many joins can you have in sql?

519

what is a database lock ? : Sql dba

589