Re: Cross-classified table

The query :

select origin, sex, count(sex) from table group by origin, sex;

gives the result :

origin | sex | count
--------+--------+-------
China | male | 2
UK | male | 1
USA | female | 1
USA | male | 2
(4 rows)

Is it enought ?

Bruno

Alexander Pucher wrote:

> Hi,
> I'm looking for the correct syntax of getting a cross-classified table
> from my SELECT statement.
>
> Let's pretend I have this table:
>
>
> origin sex
> ----------------
> USA male USA female
> China male
> China male
> UK male
> USA male
>
>
> and I want as result something like:
>
> male female
>
> USA 2 1 China 2 0
> UK 1 0
>
>
> How can I get this?
>
> Best regards,
> alex
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

--
Bruno LEVEQUE
System Engineer
SARL NET6D
bruno(dot)leveque(at)net6d(dot)com
http://www.net6d.com