Re: sql
От | Karthikeyan Sundaram |
---|---|
Тема | Re: sql |
Дата | |
Msg-id | BAY131-F50913AE1980E2A706ED12B09F0@phx.gbl обсуждение исходный текст |
Ответ на | sql ("Shyju Narayanan" <shyjukoyyam@gmail.com>) |
Список | pgsql-sql |
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" <shyjukoyyam@gmail.com> >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
В списке pgsql-sql по дате отправления: