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

1 vote322 views1 answer
Display total number of tables in mysql
SQL
9 votes343 views4 answers
SQL Date Format
SQL
2 votes324 views3 answers
Postgres remove foreign key constraint
SQL
3 votes346 views2 answers
How to list columns for particular tables in postgresql
SQL
0 vote340 views1 answer
How to use group_concat in sql server
SQL
0 vote332 views1 answer
Mysql change timestamp on update
SQL
0 vote354 views2 answers
Dumping sql table
SQL
0 vote344 views1 answer
How to add timestamp column in mysql
SQL
5 votes333 views1 answer
Oracle columns in all_tables
SQL
0 vote278 views1 answer
Copy table dbeaver
SQL