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

by

[ad_1]

In 12c the FETCH clause allows you to do this

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

4

[ad_2]

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