How select only ultimate value by month and business area?

Viewed 66

I have the table below and I would like select only the last month according business area.

These original table:

fk_month    fk_business_area
201706       8
201707       25
201707       27
201707       9
201707       8
201707       28
201707       26
201708       9

After select, I want this result:

fk_month    fk_business_area
201707      25
201707      27
201707      8
201707      28
201707      26
201708      9

Regards.

2 Answers
Related