Request a Demo
Home   >   mailing lists

Query how-to - Mailing list pgsql-sql

From Montaseri
Subject Query how-to
Date
Msg-id 8078a1730810021349y64187bem8152880a3b90184b@mail.gmail.com
Whole thread Raw
Responses Re: Query how-to
Re: Query how-to
List pgsql-sql
Tree view
Hi,

I was wondering if you can help me with the following query.

Given table T1 and columns id, start_date, stop_date and status, propose a query that reports count of items opened and closed . status is an enum including NEW, xxx, xxxx, CLOSED. The first status of an item is NEW (could be used in place of start_date)
For example

Date                     Opened        Closed
=============================
yyyy-mm-dd       25                   6
yyyy-mm-dd       0                      16
yyyy-mm-dd       12                    0
etc
etc

Thanks
Medi

pgsql-sql by date:

Previous
From: "Tony Wasson"
Date:
Subject: Re: Can COPY update or skip existing records?
Next
From: "Richard Broersma"
Date:
Subject: Re: Query how-to