Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Subquery?
- 4 Answers
- 7496 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 |
What is the difference between an inner and outer join?
What is the execution plan in sql?
what is foreign key? : Sql dba
Why are aggregate functions called so?
What is audit logout in sql profiler?
What is sql stand for?
discuss about myisam index statistics collection. : Sql dba
What is the command used to fetch the first 5 characters of a string?
Can a table have two primary keys?
sql query to get zero records from a table having n no of records
what is cursor. write example of it. What are the attributes of cursor.
What are the datatypes available in pl/sql ?
-
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)
