Symantec Access Management

How to expresss in Below code in SQL

  • 1.  How to expresss in Below code in SQL

    Broadcom Employee
    Posted Apr 16, 2019 05:56 AM

    SELECT dbo."WBSCDCL"."Group",
    COUNT( dbo.WBSCDCL.ref_num) AS TktCnt,
    dbo."WBSCDCL".ref_num
    FROM dbo."WBSCDCL"
    INNER JOIN dbo."WBSEDCL_REPORT" ON
    dbo."WBSEDCL_REPORT".ref_num = dbo."WBSCDCL".ref_num
    WHERE
    dbo."WBSCDCL"."Cat" NOT IN ('%sikkim%','%ERP%')
    AND dbo."WBSCDCL"."Group" NOT IN ('%ERP%')
    AND dbo."WBSEDCL_REPORT".action_desc LIKE 'Status changed from 'Resolved' to 'Open'%'
    GROUP BY dbo."WBSCDCL".ref_num,
    dbo."WBSCDCL"."Group"

     

     

    How to expresss in Below code in SQL

     

     

    dbo."WBSEDCL_REPORT".action_desc LIKE 'Status changed from 'Resolved' to 'Open'%'