Încearcă ceva de genul:

SELECT MIN([index]), internalID, refNo, data
FROM history2
WHERE refno='12345'
GROUP BY internalID, refNo, data

Răzvan