Search the Community
Showing results for tags '#sql'.
Hi, I need expert help to solve below problem. My data in table 'mytable' look like: customer country month cost c001 US 201506 -100 c001 DK 201506 -100 c001 DE 201506 -50 c001 FR 201507 -200 c001 UK 201507 -50 I need to get below results: customer country month cost c001 DK 201506 -100 c001 FR 201507 -200 that is 'within each month', taking 'hightest cost' generating 'country' for each customer. CATCH: in this example, we can see that in 201506, cost -100 is same for US and DK. In this case only taking either one, not both. Thanks for your help. Regards Nomann