How to find max salary in SQL without using max function?

Question

Can anyone tell me how to find max salary in SQL without using max function?

Answer 1

For SQL Server, here is the syntax to find the maximum salary of the employee table without using MAX () function:

SELECT TOP 1 Salary

FROM Employee_Table

ORDER BY Salary DESC

For SQL Server, here is the syntax to find the maximum salary of the employee table without using MAX () function:

SELECT Salary

FROM Employee_Table

ORDER BY Salary DESC

LIMIT 1

I suggest this SQL Training course by Intellipaat to learn SQL and writing complex SQL queries.