开展住房公积金审计的sql语句
时间: 2024-06-13 18:02:10 浏览: 19
在进行住房公积金审计时,SQL(Structured Query Language)语句通常用来查询、分析和报告与公积金相关的数据。以下是一些基本的SQL语句示例,用于提取住房公积金管理的关键信息:
1. 查询所有员工的公积金缴纳记录:
```sql
SELECT employee_id, name, salary, contribution_amount, contribution_date
FROM housing_fund_contribution
WHERE fund_type = 'housing公积金'
ORDER BY contribution_date;
```
2. 查询特定时间段内未缴或欠缴公积金的员工:
```sql
SELECT e.name, e.salary, c.contribution_amount, c.contribution_date
FROM employees e
LEFT JOIN housing_fund_contribution c ON e.employee_id = c.employee_id
WHERE c.contribution_date BETWEEN 'start_date' AND 'end_date'
AND c.contribution_amount IS NULL;
```
3. 计算年度公积金缴纳总额:
```sql
SELECT YEAR(contribution_date) AS year, SUM(contribution_amount) AS total_amount
FROM housing_fund_contribution
WHERE fund_type = 'housing公积金'
GROUP BY YEAR(contribution_date);
```
4. 检查是否有重复的公积金账户:
```sql
SELECT employee_id, COUNT(*) AS account_count
FROM housing_fund_contribution
GROUP BY employee_id
HAVING COUNT(*) > 1;
```
相关推荐
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)