0 - 1 of 1 tags for # CASE

SELECT  oute.*

FROM PDP_TMP.EV_SBSCRP_BTS_USG oute

WHERE  

CASE WHEN oute.PROD_TYPE= EVO

THEN oute.TotalDataCount  =  SELECT  MAX (inne.TotalDataCount)

                                                FROM PDP_TMP.EV_SBSCRP_BTS_USG inne