求一个sql大神帮忙，我要把incidentnum去重，forwarddatetime排序，现在弄的sql在navicat上查询字段少的话有数据，查全部就不行，下面是我的sql

SELECT

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 subquery

WHERE subquery.organname in ('${区域}')

and subquery.commname in ('${项目}')

and subquery.rn<=2