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

what are the disadvantages of mysql? : Sql dba

1077

What is difference between nchar and nvarchar?

958

Does sql backup shrink transaction log?

916

What is foreign key sql?

947

What are the disadvantages of not performing database normalization?

1097

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1158

How do I save the results of sql query in a file?

929

What is normalisation and its types?

957

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

934

What is the difference between sql and isql*plus?

1007

What are variables in pl sql?

1094

What is difference between sql and excel?

1010

What is difference between stored procedures and application procedures?

958

What is a sql schema used for?

1031

What is Collation Sensitivity ? What are the various type ?

906