|
楼主 |
发表于 2018-12-29 16:04:01
|
显示全部楼层
发不了截图了,代码如下:
String sql = "SELECT a.fRegisterID ,count(a.fRegisterID) as total FROM ("
+"select COMS_SX , " + " COMS_SX.fSN as fSN , " + " COMS_SX.fContractName as fContractName , "
+ " (SQL.DATEDIFF(SQL.NOW(), COALESCE(max(CA_RSX.fReceivedDate), COMS_SX.fRegisterDate))) as fMonitorDays , " + " COMS_SX.fRegisterID as fRegisterID , "
+ " COMS_SX.fRegister as fRegister , " + " COMS_SX.fStatus as fStatus " + " from COMS_SX COMS_SX optional join CA_RSX CA_RSX on COMS_SX = CA_RSX.fContractID "
+ " where ( ( COMS_SX.fDelFlag = 0 ) AND ( COMS_SX.fDataType = '合同' ) AND ( COMS_SX.fDataStatus = '最新' ) ) " + " group by COMS_SX " +
" having fMonitorDays > 365 and fRegisterID <> '' ORDER BY fMonitorDays desc "
+" ) a group by a.fRegisterID ORDER BY total DESC ";
Table table = KSQL.select(sql, null, "/COMS/ContractTermination/data", null); |
|