字段来自两张表，对incidentnum去重，对fowarddatetime时间降序取最新两条，下面是我写的，一直有问题求大佬帮忙SELECTsubquery.organname,subquery.commname,subquery.incidentdealstatename,subquery.incidentnum,subquery.coordinatenum,subquery.incidentcontent,subquery.classname,subquery.deallimit,subquery.roomid,subquery.roomname,subquery.incidentman, subquery.admiman,subquery.admidate,subquery.reservedate,subquery.dispdate,subquery.dispman,subquery.receivingdate,subquery.arrivedata, subquery.finishdate,subquery.finishuser,subquery.finishusermobiletel,subquery.ratedworkhournumber,subquery.kpiratio,subquery.dealresult,subquery.dueamount,subquery.deviceid,subquery.closetime,subquery.closeuser,subquery.closesituation,subquery.isclose,subquery.nonormalclosereasons,subquery.replycontent,subquery.replyresult,subquery.servicequality,subquery.replydate,subquery.replyman,subquery.deletedate,subquery.deleteman,subquery.deletereasons, subquery.forwardreasons, subquery.forwarddatetime,subquery.dealman FROM(SELECTa.organname,a.commname,a.incidentdealstatename,a.incidentnum,a.coordinatenum,a.incidentcontent,a.classname,a.deallimit,a.roomid,a.roomname,a.incidentman, a.admiman,a.admidate,a.reservedate,a.dispdate,a.dispman,a.receivingdate,a.arrivedata,a.finishdate,a.finishuser,a.finishusermobiletel,a.ratedworkhournumber,a.kpiratio,a.dealresult,a.dueamount,a.deviceid,a.closetime,a.closeuser,a.closesituation,a.isclose,a.nonormalclosereasons,a.replycontent,a.replyresult,a.servicequality,a.replydate,a.replyman,a.deletedate,a.deleteman,a.deletereasons, b.forwardreasons, b.forwarddatetime,a.dealman, row_number () OVER ( partition BY a.incidentnum order by b.forwarddatetime desc) AS rn FROMPMS_Base.dbo.view_HSPR_IncidentNewJH_Search_Filter as a full join PMS_Base.dbo.Tb_HSPR_IncidentForward as b on a.incidentid=b.incidentid )AS subqueryWHERE a.organname in ('${区域}')and a.commname in ('${项目}')
