Sql alternative to max statement

--Find the MAX value row without the use of the MAX() Function

select column_a, column_b, column_value
from table_name
order by column_value desc
fetch first 1 rows only;

Source: stackoverflow.com

Similar codes

2 votes145 views1 answer
How to make insert script from table in SQL server
SQL
0 vote148 views1 answer
Apex for oracle 11g
SQL
0 vote98 views1 answer
Deleted table in sql trigger
SQL
0 vote148 views1 answer
Mysql procedure between two tables
SQL
1 vote152 views3 answers
How to reset id column in sql server
SQL
3 votes148 views1 answer
Sql double index
SQL
3 votes155 views1 answer
Select sequence oracle
SQL
4 votes153 views3 answers
Sql drop primary key
SQL
2 votes134 views1 answer
Sql server find table name
SQL
0 vote117 views1 answer
Oracle sysdba connect as another user
SQL