SELECT MAX(col1) KEEP(DENSE_RANK FIRST ORDER BY col_amt1 desc) as co1,
FROM example_tb
-- In this example, col_amt1 in the example_tb table gets the value of col1 for the largest data.
Read next
From @south-man
SELECT MAX(col1) KEEP(DENSE_RANK FIRST ORDER BY col_amt1 desc) as co1,
FROM example_tb
-- In this example, col_amt1 in the example_tb table gets the value of col1 for the largest data.