Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Subquery?
- 4 Answers
- 7823 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / suresh kumar somayajula
SELECT Statement which is embedded in another class of
SELECT statement is nothing but "Sub-Query".
In this ..Inner query will execute first.based on that
result outer query will execute.
Thank you,
Suresh
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / anil_abbireddy
Runs first,executed once,returns values to be used by the
MAIN Query
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / ramesh
A sub query is a query and it is deepened main query on the another query is called as a sub-query.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rashmi
Query inside a query is called sub query. Always to execute successfully the outer query depends on the output of inner query.
it is if 4 types.
>Scalar sub query
>Corelated sub query
>Nested sub query
>Inline view
| Is This Answer Correct ? | 0 Yes | 0 No |
Which sql statement is used to return only different values?
What is Histogram?
What are the ways on commenting in a pl/sql code?
How does index help in query performance?
Is microsoft sql free?
what is csv? : Sql dba
What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?
What are the differences between implicit and explicit cursors?
Can I join the same table twice?
Can we join tables without foreign key?
What is the use of & in pl sql?
What are analytic functions in sql?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
