MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE oss_collection_history
(
org int
, Balance int
, DateFrom date
);

INSERT INTO oss_collection_history VALUES (1, 1, '2019-01-01');
INSERT INTO oss_collection_history VALUES (1, 2, '2019-01-02');
INSERT INTO oss_collection_history VALUES (2, 1, '2019-01-03');
INSERT INTO oss_collection_history VALUES (2, 2, '2019-01-04');

CREATE INDEX oss_collection_history_Charges_IDX2 
ON oss_collection_history (org, DateFrom, Balance);

EXPLAIN
SELECT och1.org
    , och1.Balance
    , och1.DateFrom
FROM oss_collection_history och1
INNER JOIN (
    SELECT MIN(och2.DateFrom) AS MinDateFrom
        , och2.org
    FROM oss_collection_history och2 
    GROUP BY och2.org
) t ON och1.org = t.org AND och1.DateFrom = t.MinDateFrom;


id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra


1
PRIMARY
och1
null
index
oss_collection_history_Charges_IDX2
oss_collection_history_Charges_IDX2
14
null
4
100.00
Using where; Using index

1
PRIMARY
<derived2>
null
ref
<auto_key0>
<auto_key0>
9
db_946870679.och1.DateFrom,db_946870679.och1.org
2
100.00
Using index

2
DERIVED
och2
null
index
oss_collection_history_Charges_IDX2
oss_collection_history_Charges_IDX2
14
null
4
100.00
Using index


SELECT och1.org
    , och1.Balance
    , och1.DateFrom
FROM oss_collection_history och1
INNER JOIN (
    SELECT MIN(och2.DateFrom) AS MinDateFrom
        , och2.org
    FROM oss_collection_history och2 
    GROUP BY och2.org
) t ON och1.org = t.org AND och1.DateFrom = t.MinDateFrom;


org
Balance
DateFrom


1
1
2019-01-01

2
1
2019-01-03

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	och1	null	index	oss_collection_history_Charges_IDX2	oss_collection_history_Charges_IDX2	14	null	4	100.00	Using where; Using index
1	PRIMARY	<derived2>	null	ref	<auto_key0>	<auto_key0>	9	db_946870679.och1.DateFrom,db_946870679.och1.org	2	100.00	Using index
2	DERIVED	och2	null	index	oss_collection_history_Charges_IDX2	oss_collection_history_Charges_IDX2	14	null	4	100.00	Using index