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
Why coalesce is used in sql?
What is left join in postgresql?
Is mariadb nosql?
Explain raise_application_error.
Which is better varchar or nvarchar?
What are the three forms of normalization?
Explain what is a column in a table?
How do I view a table in sql?
What is data control language (dcl)?
What is a null value?
What is recursive stored procedure?
what are the type of locks ? : Sql dba
discuss about myisam index statistics collection. : Sql dba
Is null operator in sql?
what is a database lock ? : Sql dba
