Expected Issue

[yangtommmmmmmm]

Could you help me explain why I get the following error when I enter the following SQL syntax，and how to modify it?

SQL syntax:
SELECT ID, name
FROM instructor
WHERE salary = (SELECT MAX(salary) FROM instructor)

Error: at line 3: Expected ";", "except", "fetch", "group", "having", "intersect", "limit", "offset", "order", "union", or end of input but "=" found.

[rlaiola]

Probably, the implementation does not cover this kind of subquery expression. However, you could use common table expressions (CTE) to get the same result.

Dataset:
https://dbis-uibk.github.io/relax/calc/gist/4f7866c17624ca9dfa85ed2482078be8/relax-silberschatz-english.txt/0

Solution (SQL):

-- common table expressions
-- https://dbis-uibk.github.io/relax/help#sql-with
WITH temp AS (SELECT max(salary) AS max_salary 
              FROM instructor)
SELECT ID, name 
FROM instructor, temp
WHERE salary = max_salary;