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 vote383 views1 answer
Mysql record group by created date count
SQL
10 votes380 views4 answers
Else if mysql
SQL
12 votes361 views4 answers
How to take database dump in postgresql
SQL
1 vote379 views1 answer
Sql how to replace full stop
SQL
0 vote343 views1 answer
How should I pass a table name into a stored proc?
SQL
0 vote344 views1 answer
Online sql testing tool
SQL
8 votes342 views1 answer
Database backup in mysql server recovery
SQL
0 vote343 views1 answer
Dapper run sql script with parameters
SQL
7 votes366 views1 answer
Return insert results in POSTGRESQL
SQL
4 votes381 views1 answer
How to drop a database in sql server when it is in use
SQL