Oracle 23c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE employment_by_industry (
    objectid int,
    agr_forest_fish int,
    mining_quarry int,
    mfg int,
    electric int,
    water_sew int
);
INSERT INTO employment_by_industry (objectid, agr_forest_fish, mining_quarry, mfg, electric, water_sew)
VALUES (1, 20797, 428, 955, 30, 70);
1 rows affected

INSERT INTO employment_by_industry (objectid, agr_forest_fish, mining_quarry, mfg, electric, water_sew)
VALUES (2, 6792, 6868, 8121, 238, 300);
1 rows affected

INSERT INTO employment_by_industry (objectid, agr_forest_fish, mining_quarry, mfg, electric, water_sew)
VALUES (3, 8728, 2405, 1544, 43, 121);
1 rows affected

select * from employment_by_industry


OBJECTID
AGR_FOREST_FISH
MINING_QUARRY
MFG
ELECTRIC
WATER_SEW


1
20797
428
955
30
70

2
6792
6868
8121
238
300

3
8728
2405
1544
43
121


select objectid, max(col_name) keep (dense_rank first order by col_val desc) max_col_name
from employment_by_industry
unpivot (
  col_val
  for col_name in (
    agr_forest_fish, mining_quarry, mfg, electric, water_sew
  )
)
group by objectid


OBJECTID
MAX_COL_NAME


1
AGR_FOREST_FISH

2
MFG

3
AGR_FOREST_FISH