asked on max query not working
SELECT Professor_Name, Salary FROM SALARIES WHERE Salary > (SELECT MIN(Salary) FROM SALARIES) * 4;
why above query not working
please advise
why above query not working
please advise
DatabasesMicrosoft SQL ServerOracle DatabaseSybase DatabaseSQL
Last Comment
slightwv (䄆 Netminder)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
It appears you want anyone making more than 4 times the minimum salary.
Every time you think you need to select from the same table again, especially in an inline query, stop and rethink it.
See if this works for you:
With all the new questions, I understand you are learning SQL. The WINDOW functions are very powerful once you understand the syntax and what they are doing.
I suggest spending some time in the documentation and other online examples.
Every time you think you need to select from the same table again, especially in an inline query, stop and rethink it.
See if this works for you:
SELECT Professor_Name, Salary from (
SELECT Professor_Name, Salary, min(salary) over() * 4 four_time_min FROM SALARIES
) salaries
where salary > four_time_min
/
With all the new questions, I understand you are learning SQL. The WINDOW functions are very powerful once you understand the syntax and what they are doing.
I suggest spending some time in the documentation and other online examples.
a query which gives a syntax error doesn't work
if it didn't work, what error did you get ?