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
Is HDATE a DATETIME field or something else? because that syntax is correct.
I solved the problem with order by Max(hdate). thanks ace21
