Oracle 18c

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

select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
0


create table table1 as  
with table1 (versionnum, project, name, type, subtype, regnum, status) as (
    select 1, 'prl', 'namel', 'typel', 'subtypel', 1, 'stat1' from dual union all
    select 2, 'prl', 'name2', 'type2', 'subtype2', 2, 'stat2' from dual union all
    select 3, 'prl', 'name3', 'type3', 'subtype3', 3, 'stat3' from dual union all
    select 4, 'prl', 'name4', 'type4', 'subtype4', 4, 'stat4' from dual union all
    select 5, 'prl', 'name5', 'type5', 'subtype5', 5, 'stat5' from dual union all
    select 5, 'pr2', 'name6', 'type6', 'subtype6', 5, 'stat1' from dual union all
    select 5, 'pr3', 'name7', 'type7', 'subtype7', 5, 'stat1' from dual)
select * from table1
7 rows affected

select * from table1
order by versionnum desc
fetch first rows with ties


VERSIONNUM
PROJECT
NAME
TYPE
SUBTYPE
REGNUM
STATUS


5
prl
name5
type5
subtype5
5
stat5

5
pr3
name7
type7
subtype7
5
stat1

5
pr2
name6
type6
subtype6
5
stat1

VERSIONNUM	PROJECT	NAME	TYPE	SUBTYPE	REGNUM	STATUS
5	prl	name5	type5	subtype5	5	stat5
5	pr3	name7	type7	subtype7	5	stat1
5	pr2	name6	type6	subtype6	5	stat1