Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / suresh.pathuri
It is the select stataement in the from clause of the another select statement .it used simplyfy the complex queries and removing the many join operations on the table.
this type
select * from(select rownum from emp order by rownum desc) suresh where rownum<=5;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many times can we commit in a loop?
How to pronounce postgresql?
What is a sql*loader control file?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
Why are aggregate functions called so?
What is sql basics?
What information is needed to connect sql*plus an oracle server?
What is primary key and unique key?
What is java sql driver?
What is character functions?
How to create your own reports in sql developer?
Explain what is a field in a database and record in a database?
What is microsoft t sql?
When sql appeared?
Which operator is used in query for pattern matching?
