Help on implementing conditional count in MYSQLReport
Please briefly explain why you feel this question should be reported .
Hi, I have a table with the following structure
Account_No D_CD A1 123 A1 246 A1 XYZ A1 100 A1 234 A2 123 A2 XYZ A3 XYZ A3 246 A3 100I would like a query that can transform the above data to the below format.
D-CD1 D_CD2 CPD 123 246 123 XYZ 123 100 123 234 XYZ 123 XYZ 246 XYZ 100FInally I want to perform count operation on each D_CD combination, the count computation should compute count of common account numbers in each D_CD combination. Any help on this topic will be greatly appreciated.