select a record based on one field being DISTINCT

[mystrymaster]

I have a database that stores Call Number, Time, and ID

I need to select all the distinct call numbers along with the times.

This is my query

SELECT Distinct Call, Time
FROM CallBack
ORDER BY Call

However this is returning duplicate call Numbers with different Times

How do I get it to only be distinct on Call and ignore the time but just give me the time?

[zone16]

hey there,

you have the same call number with different times, but just want to show one of the times ofr each call?

try something like this

select Call, max(Time)
FROM CallBack
GROUP BY Call

you can use min too...

la'ers,

zone16