Oracle 11g Release 2

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

create table qHistoryData (collectid number, update_on  number, name varchar2(50));
insert into qHistoryData values (1, 2, 'test1');     
1 rows affected

insert into qHistoryData values (2, 4, 'test2');     
1 rows affected

insert into qHistoryData values (3, 6, 'test3');     
1 rows affected

SELECT * FROM 
            (SELECT
                t2.*,
                ROW_NUMBER() OVER(
                PARTITION BY collectid
                ORDER BY
                     update_on DESC
                ) AS seqnum
                FROM
                    qHistoryData t2
                ) t
                WHERE
            t.seqnum = 1;


COLLECTID
UPDATE_ON
NAME
SEQNUM


1
2
test1
1

2
4
test2
1

3
6
test3
1