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
