Top 5 employees with the most recent changes
SQL query for BambooHR
This query will return the top 5 employees with the most recent changes in their profiles.
SELECT employee_id, MAX(change_date) FROM employee_last_change GROUP BY employee_id ORDER BY MAX(change_date) DESC LIMIT 5
BambooHR data model
Employees Directory
Employee Dependents
Employee Last Change
Company Categories
Timeoff Types
Timeoff Policies
Timeoff Requests
Job Summaries
Hiring Leads
Application Statuses
Applications
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed