How many levels can subqueries be nested in a FROM clause?
Answer Posted / vikas trivedi
32 levels of nesting within a query is possible.
| Is This Answer Correct ? | 36 Yes | 12 No |
Post New Answer View All Answers
Define overloaded procedure?
Which tcp/ip port does sql server run?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
Why we use stored procedure instead of query?
What is normalization in a database?
what are different types of collation sensitivity? : Sql dba
What are the advantages of sql?
What is the difference between cluster and non-cluster index?
what is an extent ? : Sql dba
What are properties of the transaction?
What is over () in sql?
What is rename command in sql?
Explain two easy sql optimizations.
Is ms sql is free?
What are the string functions in sql?