Women in Technology

Hear us Roar



Article:
  SQL Subqueries
Subject:   help
Date:   2005-12-22 13:12:18
From:   dazednconfused
Response to: help

Try looking up Having clause. It should work then.
Full Threads Newest First

Showing messages 1 through 1 of 1.

  • help
    2007-07-05 15:25:49  Poon [View]

    You can try :
    select * from employee where salary=(select min(salary) from employee) and
    department_id=(select min(department_id) from Department);