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.

Showing messages 1 through 1 of 1.

• help
  2007-07-05 15:25:49  Poon [Reply | View]
  
  
  You can try :
  select * from employee where salary=(select min(salary) from employee) and
  department_id=(select min(department_id) from Department);