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
How do you write a subquery?
What is interval partition?
Is it possible to sort a column using a column alias?
Is grant a ddl statement?
What are the various restrictions imposed on view in terms of dml?
What is the best sql course?
What is the life of an sql statement?
List the ways to get the count of records in a table?
What is a full join?
how to convert character strings to dates? : Sql dba
Can we use having without group by in sql?
What is nvarchar max in sql?
Write an sql query to select all records from the table?
What is raid? How does it help storage of databases?
What is group by in sql?