I'm querying a university database and trying to find a minimum of a maximum list.
Which gives...
Now I need to query the minimum salary from this list. Any suggestions?
Code:
> select name,dept_name,max(salary) as max_salary from instructor group by dept_name;
Code:
+------------+------------+------------+ | name | dept_name | max_salary | +------------+------------+------------+ | Crick | Biology | 72000.00 | | Srinivasan | Comp. Sci. | 92000.00 | | Kim | Elec. Eng. | 80000.00 | | Wu | Finance | 90000.00 | | El Said | History | 62000.00 | | Mozart | Music | 40000.00 | | Einstein | Physics | 95000.00 | +------------+------------+------------+ 7 rows in set (0.00 sec)
Comment