We've expanded our news coverage and improved our search! Visit news.oreilly.com for the latest or search for all things across O'Reilly!
advertisement

Article:
  SQL Subqueries
Subject:   help
Date:   2007-07-05 15:25:49
From:   Poon
Response to: help

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