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 can we repair a mysql table? : Sql dba
What is the process of debugging?
What is #table in sql?
What is dcl in sql?
How do I view tables in sql developer?
how can we find the number of rows in a table using mysql? : Sql dba
How to write pl sql program in mysql command prompt?
Is sql harder than python?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
What are %type and %rowtype for?
What is sql profiling in oracle?
How to get help at the sql prompt?
How to combine two stored procedures in sql?
How do you clear the screen in sql?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?