Hallo Guys,

I have an sql script which gives me the output below:

LOGIN_ID ACTION_CODE DATE CASE_REFERENCE FRAUD_TYPE_ID ESTIMATE_LOSS
james_j Assign 17/03/2008 0833003470 High Frequency 77513.92
james_j Assign 17/03/2008 0838117486 High Aggregate Cost of Calls 149830.5
james_j Assign 17/03/2008 0838521885 High Aggregate Cost of Calls 112457.79
james_j Open 17/03/2008 0832880151 High Aggregate Cost of Calls 21445.46
james_j Open 17/03/2008 0832854857 High Aggregate Cost of Calls 39037.13
james_j Open 17/03/2008 0833041781 PD Summary alarm 15537.59
james_j Open 17/03/2008 0832122779 High Aggregate Cost of Calls 17705.54
james_j Open 17/03/2008 0832126015 High Value Calls 16792.49
james_j Open 17/03/2008 0833006332 High Value Calls 26393.33
james_j Open 17/03/2008 0832725833 High Aggregate Cost of Calls 16197.94
james_j Open 17/03/2008 0832127222 High Aggregate Cost of Calls 14136.68
james_j Close 01/04/2008 0832725833 High Aggregate Cost of Calls 16197.94
james_j Close 01/04/2008 0832854857 High Aggregate Cost of Calls 39037.13
james_j Open 01/04/2008 0833041781 PD Summary alarm 15537.59
james_j Open 01/04/2008 0832725833 High Aggregate Cost of Calls 16197.94
james_j Open 01/04/2008 0832854857 High Aggregate Cost of Calls 39037.13

1. First what i wana do is to group all records according to their action code and then add the estimate loss for all records with action code close for example.

Can you please assist.

Regards,