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 vote166 views3 answers
Get free card roblox
SQL
1 vote337 views1 answer
Postgres convert text to number
SQL
0 vote265 views1 answer
Mysql grant access to one database
SQL
0 vote157 views1 answer
Sql date between one week
SQL
2 votes235 views3 answers
3 days back in sql server
SQL
0 vote166 views1 answer
Postgres set default schema
SQL
0 vote158 views1 answer
Mysql money value
SQL
0 vote179 views1 answer
Mysql return column names when table is empty
SQL
12 votes170 views1 answer
Docker mysql random root password
SQL
1 vote154 views1 answer
Jooq convert using gbk
SQL