SQL Aggregate and Scalar Functions - MySQL Tutorial #4

[@youjustgotrickrolled3843]

Thanks!

[@MaxRohowsky]

Welcome :)

[@mauriciohernandez8959]

I have a question with the next syntaxes: select firstname, lastname , max(income) from members. In the chart I saw John Oliver 90000, but the maximum income belongs to Kelly Hill. Do you know why this error happen? Thanks in advanced.

[@MaxRohowsky]

Yes, thanks for pointing it out. It's not an error it just selected the maximum income and not specifically the *row* with the maximum income.