Trying for find a minimum from maximum selection

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Steel546
    New Member
    • Mar 2009
    • 25

    Trying for find a minimum from maximum selection

    I'm querying a university database and trying to find a minimum of a maximum list.

    Code:
    > select name,dept_name,max(salary) as max_salary from instructor group by dept_name;
    Which gives...

    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)
    Now I need to query the minimum salary from this list. Any suggestions?
  • Steel546
    New Member
    • Mar 2009
    • 25

    #2
    Found answer. Thanks!
    Last edited by Steel546; Sep 28 '10, 05:00 AM. Reason: School.

    Comment

    Working...