 SQL语句： select XDJLNUM as 单号, DESCRIPTION as 描述, DA_XDJL.WAY as 方式, FLPERSON as 下令人, (select DISPLAYNAME from PERSON where personid = DA_XDJL.JLPERSON) as 记录人, STATUS as 状态, (select description from site where siteid=DA_XDJL.siteid) as 场站, (select DISPLAYNAME from PERSON where personid = DA_XDJL.cjperson) as 创建人, CJDATE as 创建时间, STOPDATE as 限电开始时间, STADATE as 限电结束时间, KEEPDATE as 累计停机小时数, LOST as 限电电量, ORDLOAD as 下令限电负荷, FCLOAD as 风场负荷, INFLOAD as 实际负荷, SSXM as 所属项目 --AVGSPEED as 平均风速（m/s）/平均光照强度（W/㎡） from DA_XDJL where (select description from site where siteid=DA_XDJL.siteid) in ${场站} and to_char(STOPDATE,'yyyy-MM-dd') >='${开始日期}' and to_char(STOPDATE,'yyyy-MM-dd') <='${结束日期}' order by (select description from site where siteid=DA_XDJL.siteid),STOPDATE |
最佳回答 |
||||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
