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

0 vote106 views2 answers
Get top 1 row of each group
SQL
5 votes117 views3 answers
Oracle list columns in schema
SQL
2 votes127 views1 answer
Where clause for child record apex
SQL
0 vote115 views1 answer
Adding primery key constraint to a column
SQL
4 votes122 views2 answers
Postgre sql create table
SQL
-1 vote150 views5 answers
Left join sql
SQL
0 vote171 views1 answer
Sql trigger to call stored procedure with parameters
SQL
1 vote111 views1 answer
Drop df constraint sql server
SQL
31 votes126 views3 answers
Sql count
SQL
0 vote123 views1 answer
Mysql filter based on datediff
SQL