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

Is postgresql a server?

997

how to use in conditions? : Sql dba

962

Why is a trigger used?

890

What is sql not null constraint?

983

what is the syntax for using sql_variant_property? : Transact sql

990

What are different functions in sql?

899

How to place comments in pl/sql?

1099

What are the different parts of a package?

1042

What are the different set operators available in sql?

974

What is plpgsql language?

980

How many types of sql are there?

930

What is difference between nchar and nvarchar?

958

What is Materialized View? In What Scenario we Use Materialized View?

9401

Is join same as left join?

979

what are the disadvantages of mysql? : Sql dba

1077