Min Funtion

  • Thread starter Thread starter CK
  • Start date Start date
C

CK

My query is based on one table listing employee names, ids, and salary. In
my query I used the min funtion to display the lowest salary; however, I'm
not able to display the employees name with the lowest salary.

Your help is appreciated.
 
On Sat, 24 Apr 2010 06:51:01 -0700, CK <[email protected]>
wrote:

You can use a subquery:
select * from Employees
where Salary = (select Min(Salary) from Employees)

This could return more than one record, if several employees share the
same lowest salary.

-Tom.
Microsoft Access MVP
 
Back
Top