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
When do we use triggers?
What does <> sql mean?
What is the best partition size for windows 10?
What are the features of pl sql?
what are integrity rules?
What is an inconsistent dependency?
what is a cursor? : Sql dba
How to avoid duplicate records in a query?
Explain the steps needed to create the scheduled job?
What do you understand by pl/sql records?
Why is partition used in sql?
how to run 'mysql' commands from a batch file? : Sql dba
What are different types of functions in sql?
What are the different types of tables in sql?
What are the sql aggregate functions?
