I'm looking for the correct syntax of getting a cross-classified table
from my SELECT statement.
Let's pretend I have this table:
and I want as result something like:
USA 2 1
China 2 0
UK 1 0
How can I get this?
pgsql-novice by date
|Next:||From: Bruno LEVEQUE||Date: 2003-10-20 19:53:09|
|Subject: Re: Cross-classified table|
|Previous:||From: Bruno LEVEQUE||Date: 2003-10-20 12:11:56|
|Subject: Re: [personal] HTML to access a database|