摘要： SELECT *FROM ( SELECT ll.* ,ROW_NUMBER() OVER ( ORDER BY ll.New DESC,ll.EditTime ) AS RID FROM ( SELECT c.* , ct.TypeName AS ''CaseType'' , cr.TypeName AS ''ReasonType'',CASE WHEN (SELECT MAX(IsLatest) FROM B_Exchange_TB WHERE CaseID = C.CaseID)=2 THEN 1WHEN (SELECT C 阅读全文