17,086
社区成员
发帖
与我相关
我的任务
分享
--实现按照ZYID和 ETYPEID分组
SELECT *
FROM (SELECT row_number() over(partition by ZYID, ETYPEID order by INFO.ID DESC) rn,
INFO.ENUM,
TY.ZYID,
INFO.ETYPEID,
INFO.ENUM,
INFO.ENUMTWO,
INFO.STIME,
INFO.ENUMTWO,
INFO.STIME
FROM TA_ANARCORD_OTHER INFO, TY_PPERAINFO TY, TA_ANARECORD TA
WHERE INFO.ANARECORDID = TA.ID
AND TA.PPERA_ID = TY.ID
AND TY.ZYID IN (1, 2, 3, 4)
AND INFO.ETYPEID in (6, 7, 8, 13, 11))
WHERE rn <= 20