Hi All<br /><br /> this is my table ;<br />| ID |entry_user_id_int | category_id_chv |<br
/>----------------------------------------------<br/>| 1 | 78 | CV |<br
/>----------------------------------------------<br />| 2 | 78 | VC |<br
/>----------------------------------------------<br/>| 3 | 78 | CV |<br
/>----------------------------------------------<br/> | 4 | 78 | CV |<br
/>----------------------------------------------<br/>| 5 | 78 | CV |<br
/>----------------------------------------------<br/>| 6 | 78 | CV | <br
/>----------------------------------------------<br/>| 7 | 78 | CV |<br
/>----------------------------------------------<br/>| 8 | 78 | CV |<br
/>----------------------------------------------<br />| 9 | 78 | VE |<br
/>----------------------------------------------<br/>| 10 | 78 | CV |<br
/>----------------------------------------------<br/>| 11 | 78 | SC | <br
/>----------------------------------------------<br/><br />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<br />result is :<br /><br />ID entry_user_id_int category_id_chv count <br /><br />1
78 VC 1<br />2 78 VE 1<br
/>3 78 CV 8 <br />4 78 SC
1<br /><br />BUT I NEED THE RESULT AS <br />entry_user_id_int COUNT(VC) COUNT(VE) COUNT(CV)
COUNT(SC) TOTAL<br /> 78 1 1 8 1 11<br /><br /><br /><br /><br />