It's more than just the MAX(). How do you find out information about the highest record?
This video explores three different analytic sql functions which can be employed to answer the question, and compares them against the ytraditional SQL method of using a subquery.
The question is answered with the MAX(), RANK(), and FIRST_VALUE() functions
Intro Music:
"Far Away (Sting)" by MK2, from the YouTube Audio Library
