multumesc de raspuyns, dar, desi internalID nu mai e duplicat, queryul nu selecteaza doar data distincta
Edit: pana la urma mi-a reusit, am pus ceva de forma:
SELECT MIN([index]), refNo, data
FROM history2
WHERE refNo='12345' and [data] in (select distinct [data]
from history2 where refNo='12345')
GROUP BY refNo, [data] order by [data] desc
banuiesc ca nu e cea mai fericita varianta, dar isi face treaba