You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
29 lines
666 B
29 lines
666 B
-- 当日体检人数统计SQL
|
|
SELECT
|
|
ROW_NUMBER() OVER (ORDER BY OrgName) AS Num,
|
|
OrgName,
|
|
ID,NAME,
|
|
CASE SEX WHEN 2 THEN '女' ELSE '男' END AS sex,
|
|
AGE,AgeClass,
|
|
SignTime,CardNo
|
|
FROM
|
|
Enrollment_Patient
|
|
WHERE
|
|
OrgName LIKE '2024年云南云澳达%'
|
|
|
|
|
|
|
|
-- 团体统计
|
|
|
|
SELECT * FROM Enrollment_OrgPatient where OID=799
|
|
|
|
SELECT * FROM Enrollment_Org where OID=731
|
|
|
|
|
|
SELECT A.ID AS EID,A.Name,Age,AgeClass,B.DeptName,B.FeeItemName FROM Enrollment_Patient A
|
|
LEFT JOIN Enrollment_FeeItem B ON A.ID=B.EID
|
|
WHERE
|
|
A.SignTime BETWEEN '2024-06-16' AND '2024-06-18'
|
|
AND B.DeptName='健康管理中心/治未病'
|
|
AND B.IsSend=1
|
|
AND B.FeeItemName LIKE '%十二%' |