SELECT
*
FROM
A
WHERE
( CASE WHEN PSTYP = '9' THEN POSID1 WHEN PSTYP = '0' THEN POSID2 END ) = '1'
DECODE(列名, 值1, 返回值1,值2,返回值2,默认值)
SELECT
*
FROM
A
WHERE
( CASE WHEN PSTYP = '9' THEN POSID1 WHEN PSTYP = '0' THEN POSID2 END ) = '1'
DECODE(列名, 值1, 返回值1,值2,返回值2,默认值)