X.UPD_DATE, Y.UPD_DATE PREV_UPD_DATE FROM (SELECT NUM, UPD_DATE, INBOUND_QTY, STOCK_ONHAND FROM TABLE2 WHERE TO_CHAR(UPD_DATE,''''YYYY/MM'''') = TO_CHAR(SYSDATE, ''''YYYY/MM'''')) X, (SELECT NUM, UPD_DATE, STOCK_ONHAND FROM TABLE2 WHERE TO_CHAR(UPD_DATE,''''YYYY/MM'''') = TO_CHAR(TO_DATE(TO_CHAR(SYSDATE, ''''YYYY/MM'''') ¦¦ ''''/01'''',''''YYYY/MM/DD'''') - 1, ''''YYYY/MM'''') ) Y, WHERE X.NUM = Y.NUM (+)AND X.INBOUND_QTY + NVL(Y.STOCK_ONHAND,0) <> X.STOCK_ONHAND ) B WHERE A.NUM = B.NUM
说明:--
SQL:
select * from studentinfo where not exists(select * from student where studentinfo.id=student.id) and 系名称=''''"&strdepartmentname&"'''' and 专业名称=''''"&strprofessionname&"'''' order by 性别,生源地,高考总成绩