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
What does truncate mean in sql?
What is the usage of the distinct keyword?
How much does a sql dba make? : SQL DBA
What is trigger types of trigger?
Is sql a backend language?
What is duration in sql profiler trace?
What is exception? What are the types of exceptions?
How many sql statements are used?
What is the difference between left and left outer join?
What are the types of index in sql?
What are the ddl commands?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
How delete all data from table in sql?
What is the use of partition by in sql?
What's the difference between a primary key and a clustered index?
