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

Question

2 Answers

Praveen_1998 · Answer 1 · 2020-05-08T14:23:37+0000

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.

Neeraj · Answer 2 · 2024-11-07T12:47:40+0000

To find max salary in sql without using max function we are going to use top keyword and order by in sql.

Select top 1 salary from tablename order by salary desc

Here we are using order by to order the column salary by descending and from that i am selecting the top 1st using top1 .