From the EMPL table, list all employees, whose salary (field SAL) is greater than one of employee Шевченко (field NAME):

Question

Accepted Answer

SELECT * FROM EMPL WHERE SAL > (SELECT SAL FROM EMPL WHERE NAME LIKE 'ШЕВЧЕНКО')

Answer

SELECT * FROM EMPL WHERE SAL > (SELECT SAL FROM EMPL WHERE NAME = 'ШЕВЧЕНКО')

Answer

SELECT * FROM EMPL WHERE SAL > MAX(SAL) AND NAME = 'ШЕВЧЕНКО'

Answer

SELECT * FROM EMPL WHERE NAME LIKE 'ШЕВЧЕНКО'

Answer

SELECT * FROM EMPL WHERE SAL > SAL('ШЕВЧЕНКО')

Crowdly