Max

[jrprogr]

I need help in getting the results:

EmpNo Empdate
----- ----------
01 06/23/2006
01 06/28/2006
02 03/24/2006
03 05/21/2006
03 06/24/2006
04 09/27/2006

Output:

EmpNo Empdate
----- ----------
01 06/28/2006
02 03/24/2006
03 06/24/2006
04 09/27/2006

 

[bborissov]

[COLOR=blue]SELECT[/color] EmpNo, [COLOR=#FF00FF]MAX[/color](Empdate) [COLOR=blue]AS[/color] Empdate
       [COLOR=blue]FROM[/color] YourTable
[COLOR=blue]GROUP[/color] [COLOR=blue]BY[/color] EmpNo

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[ninjadeathmonkey]

SELECT DISTINCT EmpNo, MAX(Empdate) AS 'Empdate'
FROM Emps
GROUP BY EmpNo

Ron Wheeler
Tekdev Open Source Development

 

[ninjadeathmonkey]

Doh! Beat to it.

Ron Wheeler
Tekdev Open Source Development

 

[jrprogr]

Thanks !!
Incase of having nulls in the table

EmpNo Empdate
----- ----------
01 Null
01 06/28/2006
02 03/24/2006
03 Null
03 06/24/2006
04 09/27/2006

Output:

EmpNo Empdate
----- ----------
01 06/28/2006
02 03/24/2006
03 06/24/2006
04 09/27/2006

 

[bborissov]

The same

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP