Re: With Clause
Date: Wed, 5 Nov 2008 02:16:10 -0800 (PST)
On 5 Nov., 11:05, raja <dextersu..._at_gmail.com> wrote:
> 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
> Apart from this, i was not able to find anything regarding WITH
> 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,
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