Hi all,
I have a table acct as (username, terminatedate, terminatecause) I would like to build a query which returns three columns orderd by data like:
date_trunc( 'day', terminatedate ) | count(cause1) | count(cause2)
where cause1/2 are two type of termination cause from the field terminatecause.
for example acct table could be:
user1|01/01/2004 01:01:01| error user2|01/01/2004 01:02:01| error user1|01/01/2004 02:00:01| normal user3|02/01/2004 10:00:01| normal user2|02/01/2004 10:10:01| error
I would like to obtain:
date |normal| error 01/01/2004| 1 | 2 02/01/2004| 1 | 1
Thanks in advance.
Roberto Fichera.
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
