SELECT
d.department_name, emplyee_name, max_salary
FROM
employee
JOIN
department d
ON employee.department_id = d.department_id
JOIN(SELECT department_id,MAX(salary)as max_salary
FROM employee
GROUPBY department_id)tempONtemp.department_id = d.department_id
WHERE
employee.salary = max_salary
ORDERBY
max_salary DESC;
2
SELECT new_id as id ,student
CASEWHENMOD(id,2)>0THEN id-1ELSE id-1ENDAS new_id
FROM seat
ORDERBY new_id ASC;
3
SELECT Score,
DENSE_RANK()OVER(ORDERBY score DESC)as Rank
FROM Scores;
习题1231SELECT d.department_name, emplyee_name, max_salaryFROM employeeJOIN department d ON employee.department_id = d.department_idJOIN (SELECT department_id, MAX(salary) as max_salary FROM employee GROUP BY department_id) temp ON temp.dep