Re: [SQL] group by range of values

[Rodrigo De León]

On 7/27/07, Carol Cheung <[EMAIL PROTECTED]> wrote:
> Something like:
>
> decade | average(salary)
> -------+-----------------
>    1940 |  69500
>    1950 |  53333.33
>    1960 |  53000
>    1970 |  40333.33

CREATE TABLE tester (
  birth_year integer,
  salary numeric(10,2)
);

SELECT
SUBSTRING(TO_CHAR(BIRTH_YEAR,'FM9999') FROM 1 FOR 3)||'0'
AS DECADE
, AVG(SALARY) AS AVG_SALARY
FROM TESTER
GROUP BY
SUBSTRING(TO_CHAR(BIRTH_YEAR,'FM9999') FROM 1 FOR 3)||'0'
ORDER BY DECADE;

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend