How to Use the Min Function to Look for a Specific Date?

[VAST39]

Hey guys,

I'm a bit stuck on a simple query. I can't remember how to use the min function to compare against a specific date. For my query, I want to find employees where their first service date occurs after july 1, 2005. I wrote this query, but I get a syntax error:

SELECT  SSSN from history
where min(B.SERVICEDT) > '2005-07-01'

What am I missing here?

 

[bborissov]

SELECT SSSN
from history
HAVING min(history.SERVICEDT) > '20050701'

?

Borislav Borissov
VFP9 SP2, SQL Server

 

[VAST39]

That worked. Thanks!

 

[bborissov]

Sorry, you should add GROUP BY:

SELECT SSSN
from history
GROUP BY SSSN
HAVING min(history.SERVICEDT) > '20050701'

Borislav Borissov
VFP9 SP2, SQL Server