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

How many times can we commit in a loop?

1000

what is bcp? When is it used?

1093

What are the commands used in sql?

1048

what is index? : Sql dba

990

what are enums used for in mysql? : Sql dba

1158

what is bcp? When does it used? : Sql dba

975

Why is pl sql needed?

920

Does oracle roll back the transaction on an error?

1000

What are sql built in functions?

922

Why is %isopen always false for an implicit cursor?

1086

what are dynamic queries in t-sql? : Transact sql

1004

what is 'trigger' in sql? : Sql dba

1068

What version is sql?

1008

Show the two pl/sql cursor exceptions.

1167

Which is faster count (*) or count 1?

1010