Yes this is possible. Your query has several syntax errors however.
- a dash in an identifier is invalid. I used an underscore instead in the below example. If you did create the columns that way, you will need to quote them, e.g.
- the equality operator in SQL is
- String constants need to be put in single quotes (
') not double quotes
It is possible to use the result of the max subquery as a single values because it is a single value. To be accurate it is a subquery that because of the
max() returns a single column and a single row.
where salary > (select max(salary)
where company_name = 'Google');
You could use an alternative way with
> ALL instead of
>, with a subquery that doesn't have an aggregate function and returns many values (many rows but still a single column):
where salary > ALL (select salary
where company_name = 'Google'
and salary is not null );
salary is not null condition in this second query. Nulls must be taken out of the comparison because each of them would evaluate the
> operation to unknown rather than true or false, and as a result the whole
> ALL condition result would be unknown and you would get no rows in the output.