sub query

[Former Member]

what is sub query?

[Former Member]

Sub query is query inside a query

Eg

select country from dbtab1

where country not in (select country from dbtab2).

Reward if useful

[Former Member]

Hi,

A subquery is a special SELECT statement containing a subquery within particular conditions of the WHERE or HAVING clauses. You cannot use them in the ONcondition of the FROM clause. Their syntax is:

( SELECT result

FROM source

[WHERE condition]

[GROUP BY fields]

[HAVING cond] )

In simple language,

Query inside Query.

Output of inner query will be given to the outer query.

Reward if useful!

[Former Member]

THANK U.