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
what is “go” in t-sql? : Transact sql
What does sign mean sql?
What are pl/sql cursor exceptions?
How do you respond to dementia behavior?
What do you understand by pl/sql records?
What is the difference between sql and mysql?
How many types of keys are there in sql?
What is a null value?
How do I clear the screen in sql plus?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
how to add a new column to an existing table in mysql? : Sql dba
how many groups of data types? : Sql dba
What is prepared statement in sql?
What is clause in sql?
Differentiate between pl/sql and sql?
