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 is the maximum rows in csv?
Which one is better subquery or joins?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
What is sql indexing?
In a distributed database system, can we execute two queries simultaneously?
What is interval partition?
Can you load data into multiple tables at once? : aql loader
What is the use of double ampersand (&&) in sql queries? Give an example
What are the subsets of sql?
What is the difference between database trigger and stored procedure?
what happens if null values are involved in expressions? : Sql dba
what is uncommittable transactions? : Transact sql
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
Explain correlated query work?
What is embedded sql in db2?
