Skip to content

1 or 2 credits, some free · 1 credit is about $1

pocketshelf

HR and Payroll SQL: Reporting Queries

A 2-page snippet pack for reporting and analytics queries for an HR and payroll database (employees and timesheets): 12 short entries with copy-ready code.

ForDevelopers

sql-reporting-queries-for-hr-and-payroll.pdfShowing 20 of 78 lines
// timesheets per month
SELECT date_trunc('month', work_date) AS month, count(*) AS timesheets
FROM timesheets
GROUP BY 1
ORDER BY 1;

// Top employees by hours
SELECT p.full_name, sum(c.hours) AS total
FROM employees p
JOIN timesheets c ON c.employee_id = p.id
GROUP BY p.id, p.full_name
ORDER BY total DESC
LIMIT 10;

// Share by status
SELECT status, count(*) AS n,
       round(100.0 * count(*) / sum(count(*)) OVER (), 1) AS pct
FROM timesheets
GROUP BY status
ORDER BY n DESC;

What's inside

Format
PDF, Markdown, SQL
Contents
12 queries
Version
1.0 · Updated 3 Oct 2026
Licence
Commercial What this means
Checked
Checked before it ships
  • sql-reporting-queries-for-hr-and-payroll.pdfPDF · 21 KB
  • sql-reporting-queries-for-hr-and-payroll.mdMarkdown · 3 KB
  • sql-reporting-queries-for-hr-and-payroll.sqlSQL · 3 KB
  • LICENSE.txtadded to every download

About this item

A compact, printable snippet pack for reporting and analytics queries for an HR and payroll database (employees and timesheets). Each of the 12 entries has a one-line explanation and a small example you can paste into your editor. The PDF uses a two-column A4 layout designed to sit next to your keyboard, and the same content ships as Markdown so you can search it or drop it into your notes, plus a .sql file with every query. Every SQL example targets PostgreSQL 16.

Reviews

No reviews yet.

You might also grab