List of employees with the highest total hours worked
SQL query for NMBRS
Get a list of employees with the highest total hours worked.
SELECT e.employee_name, SUM(e.total_hours) as total_hours_worked FROM (SELECT employee_id, SUM(hours_worked) as total_hours FROM employee_fixedhours UNION ALL SELECT employee_id, SUM(hours_worked) as total_hours FROM employee_variablehours) e GROUP BY e.employee_name ORDER BY total_hours_worked DESC
NMBRS data model
Debtors
Companies
Company Addresses
Company Costcenters
Company Costunits
Company Hourcodes
Company Payroll Runs
Company Schedules
Company Wagemodels
Contracts
Departments
Employee Absences
Employee Addresses
Employee Costcenters
Employee Costperhour
Employee Departments
Employees
Employee Details
Employee Extrafields
Employee Fixedhours
Employee Fixedwagecomponents
Employee Functions
Employee Labouragreements
Employee Parentalleave
Employee Personal Info
Employee Salaries
Employee Variablehours
Employee Variablewagecomponents
Employments
Leave Balances
Leave Groups
Leave Requests
Managers
Payroll Run Employees
Schedules
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