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 |
Post New Answer View All Answers
what are the disadvantages of mysql? : Sql dba
What is difference between nchar and nvarchar?
Does sql backup shrink transaction log?
What is foreign key sql?
What are the disadvantages of not performing database normalization?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
How do I save the results of sql query in a file?
What is normalisation and its types?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What is the difference between sql and isql*plus?
What are variables in pl sql?
What is difference between sql and excel?
What is difference between stored procedures and application procedures?
What is a sql schema used for?
What is Collation Sensitivity ? What are the various type ?