Thread: Min Function
View Single Post
  #10 (permalink)  
Old September 22nd, 2006, 01:40 PM
deontae45 deontae45 is offline
Authorized User
Join Date: Sep 2006
Location: Montgomery, Alabama, USA.
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts

Thanks Jeff I figured it out.
SELECT vchNumberCalls as 'Number of Calls', vchSpecialistName
FROM tblConsumerSpecialists
WHERE vchNumberCalls = ((SELECT MIN(vchNumberCalls)
                            FROM tblConsumerSpecialists))

Alexander Nelson
Reply With Quote