WITH T AS (
           SELECT  C.*,
                   COUNT(DISTINCT ATTRID) OVER() CNT
             FROM  CARDATTRS C
             WHERE OBJECTID = '3092802'
               AND ATTRCODE = 'STATEID'
               AND ATTRID IN (13000411,13000412)
          )
SELECT  *
  FROM  T
  WHERE CNT = 2
/

WITH T AS (
           SELECT  ID,
                   SUM(
                       DISTINCT CASE ATTRID
                                  WHEN 13000411 THEN 1
                                  WHEN 13000412 THEN 2
                                END
                      ) OVER() FLAG
             FROM  CARDATTRS
             WHERE OBJECTID = '3092802'
               AND ATTRCODE = 'STATEID'
          )
SELECT  ID
  FROM  T
  WHERE FLAG = 3
/

SELECT  ID
  FROM  CARDATTRS
  WHERE OBJECTID = '3092802'
    AND ATTRCODE = 'STATEID'
    AND ATTRID IN (13000411,13000412)
  GROUP BY ID
  HAVING COUNT(DISTINCT ATTRID) = 2
/