SELECT COUNT(*) AS NUM FROM UN_INSPB_CASE_DOCUMENT
WHERE ( SELECT
CASE
WHEN
( UN02_DOCUMENT_TYPE = 'A-FR' ) THEN
'UN02_CASOU_NUM' ELSE 'UN02_CASE_NUM'
END
FROM
UN_INSPB_CASE_DOCUMENT WHERE UN02_CASE_NUM='8362b4efaffd448bb6e91cea77026647'
AND UN02_DOCUMENT_TYPE='A-FR'
AND UN02_DOCUMENT_CODE = 'ATF' ) ='PAF(no00002-PAF1995/2a REPARTI??O FISCAL/1996)'
這個sql有什么問題嗎,為啥沒有得到我想要的值
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/283865.html
標籤:開發
上一篇:SQL
下一篇:請教水平分表的問題?