Thread: Min Function
View Single Post
  #1 (permalink)  
Old September 22nd, 2006, 12:56 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
Default Min Function

Can someone help me?
I'm trying to get a record for a table with the least amount of calls. I'm using this code in SQL but it is not working:

select MIN(vchNumberCalls)as 'Number of Calls', vchSpecialistName
from tblConsumerSpecialists
When I run this code it returns the correct number, but I need the Name that goes along with that number.

select MIN(vchNumberCalls)as 'Number of Calls'
from tblConsumerSpecialists

Alexander Nelson
Alexander Nelson