SQL ઈન્ટરવ્યુ માટેના સવાલ જવાબ

1.

Select a Row from the Outer Query
2.

Determine the value of the correlated column(s)
3.

For each record of the outer query, the inner query is executed
4.

The result of the inner query is then fed to the outer query and evaluated. If it satisfies the criteria, the row is returned for output
5.

The next record of the outer query is selected and steps 2 through 4 are repeated until all the records of the outer query are evaluated