Hi,
I have a question about using Group By.
On a table like this:
Type (varchar) | Active (boolean)
--------------------------------------------------------
Type One | False
Type Two | True
Type One | True
Type Fifty | Flase
Type Two | True
Having this table I want a report grouping Types and giving me more
statistics such as:
Type | Active Count | Inactive Count | Active
Percent
How do i do that?
I can think of :
select Type from table_name group by Type
But that doesn't give me how many active and inactive each had!
Please help me here understand how to approach this.
Thank you,
Mike
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
