Hello Team,
I am again stuck up with SQL Query.
I need the MINUS Count from SQL Select Query.
I am sharing my query -
--------
SELECT stockcerti.Location AS 'Stock Location', stockcerti.CertifiedBy AS 'Stock Owner', cast(stockcerti.CertifiedOn as date) AS 'Date : DD/MMM/YYYY HH:MM', COUNT(*) AS 'Certified Stock', ( select count(*) from tblMasterEntry lotmasterentry left outer join tbLocOwnerMap locown on locown.AssetLocId =lotmasterentry.varLocationId and locown.AssetLoc = lotmasterentry.varLocation and lotmasterentry.charSt = 'N' where lotmasterentry.varLocation = stockcerti.Location and locown.AssetCSO = stockcerti.CertifiedBy and lotmasterentry.varLocation is not null ) AS 'TotalStock' FROM tbl_StockOwner_AssetCertification stockcerti where stockcerti.CertifiedBy = 'Prasannakumar.Merugu' --left outer join tblAssetLocOwnerMap assetloc on assetloc.AssetCSO = stockcerti.CertifiedBy GROUP BY stockcerti.Location, stockcerti.CertifiedBy,cast(stockcerti.CertifiedOn as date)
-----------------------
Here, I need 1 column "Pending" that is - [Total Stock] - [Certified Stock].
Please guide - How do I do this ?