Re: With Clause

On 5 Nov., 11:05, raja <dextersu..._at_gmail.com> wrote:
> Hi,
>
> I had a look at the usage of WITH Clause, where a repeated subquery
> can be replaced using WITH clause which reduces the complexity of the
> query.
> Apart from this, i was not able to find anything regarding WITH
> Clause.
>
> Please reply to my doubts on WITH Clause :
> 1. Apart from subquery replacement, what are the other usages of WITH
> Clause ?
> 2. Will the performance increase if we are using WITH Clause, instead
> of a subquery ?
> 3. What is the difference between WITH Clause and correlated
> subquery ?
>
> Any other information regarding WITH Clause, please send them too.
>
> Thanks in Advance.
>
> With Regards,
> Raja.

a with-subquery can be referenced multiple times in a selectstatement.  not so a subquery defined in the from-clause. Received on Wed Nov 05 2008 - 04:16:10 CST