try this:
select entry_user_id, sum(decode(entry_user_id,'VC',1,0) as vc,
sum(decode(entry_user_id,'VE',1,0) as ve,
sum(decode(entry_user_id,'CV',1,0) as cv,
sum(decode(entry_user_id,'SC',1,0) as SC
from vigilance_master group
where entry_user_id=78
group by entry_user_id
From: "Shyju Narayanan" <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: [SQL] sql
Date: Fri, 2 Feb 2007 13:09:09 +0530
Hi All
this is my table ;
| ID |entry_user_id_int | category_id_chv |
----------------------------------------------
| 1 | 78 | CV |
----------------------------------------------
| 2 | 78 | VC |
----------------------------------------------
| 3 | 78 | CV |
----------------------------------------------
| 4 | 78 | CV |
----------------------------------------------
| 5 | 78 | CV |
----------------------------------------------
| 6 | 78 | CV |
----------------------------------------------
| 7 | 78 | CV |
----------------------------------------------
| 8 | 78 | CV |
----------------------------------------------
| 9 | 78 | VE |
----------------------------------------------
| 10 | 78 | CV |
----------------------------------------------
| 11 | 78 | SC |
----------------------------------------------
WHEN "select entry_user_id_int, category_id_chv,count(category_id_chv) from
vigilance_master group by category_id_chv,entry_user_id_int having"
entry_user_id_int=78
result is :
ID entry_user_id_int category_id_chv count
1 78 VC 1
2 78 VE 1
3 78 CV 8
4 78 SC 1
BUT I NEED THE RESULT AS
entry_user_id_int COUNT(VC) COUNT(VE) COUNT(CV) COUNT(SC) TOTAL
78 1 1 8 1 11
_________________________________________________________________
Get in the mood for Valentine's Day. View photos, recipes and more on your
Live.com page.
http://www.live.com/?addTemplate=ValentinesDay&ocid=T001MSN30A0701
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
