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

3 votes351 views1 answer
Ssh check mysql version
SQL
2 votes368 views1 answer
How to delete view in sql
SQL
22 votes348 views4 answers
Show list of users in mysql
SQL
6 votes379 views2 answers
Mysql 1 day ago
SQL
0 vote387 views1 answer
Oracle swap partition
SQL
0 vote359 views1 answer
Mysql root localhost run
SQL
0 vote365 views1 answer
Oracle change password expiration policy
SQL
0 vote383 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote343 views1 answer
Django mysqlclient connection string
SQL
4 votes357 views2 answers
Bulk kill mysql processlist
SQL