SQL Query issue
I have an issue and not sure how to fix. My table is a "log" that detects the level of access an employee have at a given time. My table look like this
Id (Int) Auto increment
Name (varchar)
Logon_id (varchar)
Department (varchar)
Access_level (varchar)
Date_of_change (timestamp) CURRENT_TIMESTAMP
I want to generate a report that shows the current Access_level for each employee.
The employee should only be shown once, with the latest Date_of_change and the current Access_level at that date.
Any ideas? Thanks in advice
Regards
Rune