[Solved] SQL – How to select a row having a column with max value without using sub query in Oracle

Question

In 12c the FETCH clause allows you to do this

select * from the_table
 order by value desc
 FETCH FIRST 1 ROWS WITH TIES;

Accepted Answer

In 12c the FETCH clause allows you to do this

select * from the_table
 order by value desc
 FETCH FIRST 1 ROWS WITH TIES;