3 Sub Query

Question 1

define sub query

Answer 1

the Query within a Query is called the sub query

Question 2

where we can write sub query

Answer 2

near select, from , where

Question 3

to comare single value we use

Answer 3

>

Question 4

to comare multiple value we use

Answer 4

all , any

Question 5

All

Answer 5

this will give all values apart form specified.

Question 6

any

Answer 6

this will give all values and also specified.

Question 7

Corelated

Answer 7

if the output sq depend on in ternal sq(subquery)

Question 8

which runs first internal sq or External sq

Answer 8

internal sq

Question 9

for each transcation of _______ sq the ______ sq will run individually

Answer 9

internal sq , outer sq

Question 10

disadvantage of corelated sub query

Answer 10

time consuming