MAX

How can we find the highest employee salary?

Intermediate⏱ 3 Minutes⭐ 790 XP

🤔 THE QUESTION

How can we find the highest employee salary?

💡 WHAT IS IT?

MAX() identifies the largest numerical, alphabetical, or chronological value in a column.

🎯 WHAT IS IT USED FOR?

Peak compensation, latest transaction timestamps, maximum server response times.

💻 EXAMPLE

SELECT MAX(salary) AS maximum_salary
FROM employees;

Practice typing production-grade SQL code for MAX.