text to sql syntaxThu, 29 Feb 2024

-----------+-------+--------+ develop | 11 | 5200 | develop | 7 | 4200 | develop | 9 | 4500 | develop | 8 | 6000 | develop | 10 | 5200 | personnel | 5 | 3500 | personnel | 2 | 3900 | sales | 3 | 4800 | sales | 1 | 5000 | sales | 4 | 4800 | Задача: написать запрос, чтобы получить empno с самой высокой зарплатой

T * FROM employees WHERE salary=(SELECT MAX(salary) FROM employees); +----+--------+ | id | salary | +----+--------+ | 1 | 10 | | 2 | 20 | | 3 | 30 | +----+--------+ 3 rows in set (0.00 sec) mysql> SELECT * FROM employees WHERE salary=(SELECT MAX(salary) FROM

Want to kickstart your project?Use the new AI Studio to create your code