Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

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 by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #sql #alternative #max #statement
ADD COMMENT
Topic
Name
7+6 =