Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
[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
SELECT DISTINCT EmpNo, MAX(Empdate) AS 'Empdate'
FROM Emps
GROUP BY EmpNo