How to list all employees having percentage greater than some number, and percentage gets calculated on the basis of max salary.
Example:
if max salary is 100 and an employee salary is 50 then percentage should show 50.
This is what i tried:
select (salary/Max(salary)*100) as percentage from test.employeetable
where percentage > 75;
Error that i get is:
Unknown column 'percentage' in 'where clause