Nested Queries

Let us see some more complex queries in this section.

Sub-queries:

Some of the basic concerns of sub-queries are:

• A sub-query is a SELECT statement that is fixed in a clause of another SELECT statement. They are often referred to as a SUB SELECT or NESTED SELECT or INNER SELECT.
• The sub-query (inner query) implements first before the main query. The product of the sub-query is used by the outer query (main query).
• Sub-query can be placed in HAVING or WHERE or FROM clauses.
• Format of using sub-queries:

                 SELECT

                 FROM

                 WHERE expr OPERATOR

                                                          (SELECT FROM

WHERE);

                Operator has a comparison operator (one or multiple row operators)

Single row operator:   >, =, >=, <, <=, <>

                         Multiple row operators: IN, ALL, ANY,

• Order by clause can't be used in sub-query, if specified it must be the end clause in the main select statement.
• Parts of sub-queries:

         ‰  Single row sub-query: It gives only single row from the inner select statement.

        ‰   Multiple row sub-queries: It gives more than single row from the inner select statement

        ‰  Multiple column sub-queries: It gives more than single column from the inner select statement.

Single row operators are used with one row sub queries and multiple row operators are used with numerous row sub queries.

• The Inner and Outer queries can get data from different tables.
• Group Functions are used in sub queries.

Posted Date: 3/11/2013 3:36:58 AM | Location : United States

Ask an Expert

Related Discussions:- Nested queries, Assignment Help, Ask Question on Nested queries, Get Answer, Expert's Help, Nested queries Discussions

Write discussion on Nested queries
Your posts are moderated

Write your message here..

Related Questions

Database structures, 3 assignments combined in 1 3 assignments combined in 1

Dbms of company, what should be included in this??? what should be included in this???

Creating database for library, i need help with creating database system fo... i need help with creating database system for a library

The maximum no of key fields that can be used in a header, The Maximum no o... The Maximum no of key fields that can be used in a header is?? 50

Relational database design, how to find entities how to find entities

Normalization database, I need some help with my normalization database hom... I need some help with my normalization database homework.

What is datawarehousing, What is DataWarehousing? Subject-oriented, me... What is DataWarehousing? Subject-oriented, meaning that the data in the database is organized so that all the data elements relating to the similar real-world event or object

What are the desirable properties of a decomposition, Define What are the d... Define What are the desirable properties of a decomposition Ans: What are the desirable properties of decomposition - dependency preserving.  Because Lossless join and dependen

What is a view, What is a view?  Make a view of EMP table named DEPT 20, to... What is a view?  Make a view of EMP table named DEPT 20, to display the employees in department 20 and their annual salary.  Ans:  View is a virtual table that does not consist

The file based system in dbms, The File Based System File based systems... The File Based System File based systems are an early attempt to computerise the manual filing system. For example, a manual file can be set up to hold all the correspondence r