What is the Subquery?
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 |
how to debugg a procedure or package using dbms_output.put_line in plsql
how to return query output in html format? : Sql dba
What are aggregate and scalar functions?
Explain the types of joins in sql?
Mention what are different methods to trace the pl/sql code?
What is optimistic concurrency control? : Transact sql
How the execution will be done in exceptions?
How to write a query to show the details of a student from students table whose
What are secondary keys?
Does pl/sql support create command?
What does pl sql developer do?
What is sql entity?
Oracle (3259)
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)