Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Max
- Thread starter jrprogr
- Start date
Code:
[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] EmpNoBorislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP
ninjadeathmonkey
Programmer
Code:
SELECT DISTINCT EmpNo, MAX(Empdate) AS 'Empdate'
FROM Emps
GROUP BY EmpNoRon Wheeler
Tekdev Open Source Development
ninjadeathmonkey
Programmer
- Thread starter
- #5
- Status
Similar threads
