create table VisitRemind as (
SELECT
a.sourceType,
a.sourceId,
a.gender,
a.nowAddress,
a.diseaseType,
a.dataBirth,
a.VISIT_DATE,
a.patientId,
a.tel,
a.`name`,
a.dutyUserUuid,
a.sourceTable,
a.mbType,
a.INPUT_USER_ID,
a.DUTY_USER_ID,
a.NEXT_DATE
FROM VIEWRESIDENTHIST a
where 1=1
and (sourceType, patientId,NEXT_DATE) in ( SELECT sourceType, patientId, MAX( NEXT_DATE ) FROM VIEWRESIDENTHIST GROUP BY sourceType, patientId ) )
MYSQL通过查询到的数据新建一张表
最新推荐文章于 2024-05-19 03:18:57 发布