【数据库系统】大学模式SQL查询题解

1.Find the highest salary of any instructor.

select max(salary)
from instructor

2.Find all instructors earning the highest salary (there may be more than one with the same salary).

select ID, name 
from instructor 
where salary = (select max(salary) from instructor)