On Tue, Aug 02, 2005 at 14:34:46 -0400,
Henry Ortega <[EMAIL PROTECTED]> wrote:
> I have the ff table:
>
> id |total| effective|end_date
> john 6 01-01-200502-28-2005
> john 8 03-01-200506-30-2005
>
> How
Henry Ortega wrote:
> I have the ff table:
>
> id |total| effective|end_date
> john 6 01-01-200502-28-2005
> john 8 03-01-200506-30-2005
>
> How can I return:
> id |total| effective
You are looking for what is commonly referred to as a "pivot-table" or a
"cross-tab". Pivot-tables are a fairly sophisticated, non-normalized view of
a dataset, nd most commonly appear in spreadsheets and are used for
financial or statistical analysis.
These queries typically use an aggregate f
I have the ff table:
id |total| effective|end_date
john 6 01-01-200502-28-2005
john 8 03-01-200506-30-2005
How can I return:
id |total| effective|end_date
john 6
