oracle中多行数据转换为多列
CREATE OR REPLACE VIEW VIEW_LC_REALDATA_DY ASSELECTterminalno,terminalname,terminaltime,servertime,direction,MAX(DECODE(dataitemno,'1',receivedata)) AS ady,MAX(DECODE(dataitemno,'2',receivedata)) AS...
原创
2014-09-15 17:39:16 ·
1923 阅读 ·
0 评论