1.txt

来自「This is example for E-Market to use sequ」· 文本 代码 · 共 1 行

SELECT SN FROM edmi.viewmetercontact WHERE SN in (Select SN FROM tblslac WHERE recdate = to_date('13-05-2009','dd-mm-yyyy') AND errorsource like '%96%') and recdate = to_date('13-05-2009','dd-mm-yyyy') Group by SN Order by SN