SELECT '573' CITY_ID,CASE WHEN SF.FDBH=2 THEN '11943000' WHEN SF.FDBH=7 THEN '11943001' WHEN SF.FDBH=12 THEN '11943002' WHEN SF.FDBH=9 THEN '11943003' WHEN SF.FDBH=11 THEN '11943004' ELSE '' END JDFDBH,JD.JDSKU,SF.LSDJ AS LSDJ,' ' SCJ
FROM SPXX_JB S, SPXX_JD JD, SPXX_FD SF, SPKCZT SK
WHERE SF.SP_ID=S.SP_ID AND
SF.SP_ID=SK.SP_ID AND
SF.FDBH=SK.FDBH AND
JD.SPCODE=S.SPCODE AND JD.JDSKU IS NOT NULL AND trim(translate(JD.JDSKU,'0123456789',' ')) is NULL AND SF.FDBH=:FDBH
ORDER BY SF.CXLSDJ
以上是原始的查詢陳述句，想查詢1000-2000條之間的記錄，而且不顯示rownum
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/266464.html
標籤：數據庫相關
上一篇：問各位大佬一個問題，請幫忙解答下
下一篇：求一個PI OLEDB的包謝謝