求一个sql大神帮忙，我要把incidentnum去重，forwarddatetime排序，现在弄的sql在navicat上查询字段少的话有数据，查全部就不行，下面是我的sqlSELECT subquery.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 (SELECT a.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 FROM PMS_Base.dbo.view_HSPR_IncidentNewJH_Search_Filter AS a left JOIN PMS_Base.dbo.Tb_HSPR_IncidentForward AS b ON a.incidentid = b.incidentid ) AS subqueryWHERE subquery.organname in ('${区域}')and subquery.commname in ('${项目}')and subquery.rn<=2
