How to find the max salary in the table? If the max salary has for 2 employees.
EMP Salary
1 1000
2 1000
3 50
How to find the max salary in the table? If the max salary has for 2 employees.
EMP Salary
1 1000
2 1000
3 50
there are two max values in salaries.
I need those two as output.
In my case it might not work
hey @manikanta-balusa-48bad528 i have created the dummy table as per your question.so it will work.
in output if you want to show only one then go for this
select * from doubt
where salary in(select max(salary) from doubt)
limit 1;
if you want both then go for this
select * from doubt
where salary in(select max(salary) from doubt);
run whatever you need it will work.