Re: Basic oracle question

From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 3 Apr 2003 12:17:15 -0800
Message-ID: <1b061893.0304031217.19a72f07_at_posting.google.com>


-Where clause is executed to get the resultset,
-Group by is executed with the aggregation functions if any
-Select part is executed 

Daniel

raghu_work_at_hotmail.com (Raghu) wrote in message news:<cc839342.0304030025.394d1c58_at_posting.google.com>...
> Hi,
> I want to know the order in a query with a group by is executed.
>
> My current assumption is regarding my assumption that,
> -Where clause is executed to get the resultset,
> -Select part is executed
> -Group by is executed with the aggregation functions if any
>
> Any pointers on this will be useful.
>
> Thanx,
> Raghu.
Received on Thu Apr 03 2003 - 22:17:15 CEST

Original text of this message