odbc - date

wxdqz

New Member
I want to find the latest date for a particular column. Here is what I am using now.

select max(hdate) as hiredate from employees where dept='sales'

this only seems to return the first entry in the database regardless of date.

Ace21
 
Back
Top