Use myql statistical payrolls every month-CodePudding

CodePudding

Home > database > Use myql statistical payrolls every month

Use myql statistical payrolls every month

Time：09-16

The status in time departure time
On-the-job/departure

CodePudding user response:

Reference sticky stick, the wisdom of the question!

CodePudding user response:

Select year (in time), month (in time), count (1) from the table where induction time & gt;='* * * and induction time & lt; '* * *' and status='on-the-job'
Group by year (in time), month (in time)

Page link：https//www.codepudding.com/database/2820.html

Prev:Mysql in select count (*) from the user where the username='% % ss' query returns a value

Next:About varchar and char influence on the performance of the table, don't have to query the field

Tags：

MySQL

Links：
CodePudding