Interested to Buy Any Domain ? << Click Here >> for more details...
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
Please Help Members By Posting Answers For Below Questions
Define a temp table?
How many sql statements are used?
What is the purpose of cursors in pl/sql?
Why do we use procedures in sql?
What is mutating trigger?
What is a ddl command?
What is rename in sql?
What is trigger price?
how to enter numeric values as hex numbers? : Sql dba
What is nvl?
How do you update a table in sql?
What is the best sql course?
Can we perform dml in function?
Explian rowid, rownum? What are the psoducolumns we have?
What found sql?
