select * from (select a.*,rownum aa from orders a ) where aa=2 Please

how to retrive only second row from table?

Question Posted / rajasekar.p

Answer Posted / rajasekar.p

select * from (select a.*,rownum aa from orders a )
where aa=2

Please verify the same you will get the correct answer

Regards
P.Rajasekar

Is This Answer Correct ?

5 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Are dml statements autocommit?

1045

what is bdb (berkeleydb)? : Sql dba

1035

What does trigger mean in psychology?

962

What is auto increment?

1000

Give the order of sql select?

1137

What is java sql connection?

1061

what is auto increment? : Sql dba

1011

What is a common use of group by in sql?

1051

How can you know that statistics should be updated?

1079

What is difference between inner join and cross join?

969

What is before and after trigger?

960

Why is theta join required?

1146

Explain the update statement in sql

994

Does varchar need length?

995

Is natural join same as inner join?

943