Monday, 22 September 2025

Find the missing data comparing two users. same table

 SELECT a.Site_Location

FROM tbl_UserAccessEntities a

LEFT JOIN tbl_UserAccessEntities b

    ON a.Site_Location = b.Site_Location

   AND b.User_ID = 'EROOSENSCHOON'

   AND b.country_code = 'US'

   AND b.Division_ID = 'msv'

WHERE a.User_ID = 'Scooper'

  AND a.country_code = 'US'

  AND a.Division_ID = 'msv'

  AND b.Site_Location IS NULL;




No comments:

Post a Comment

HCL healthcare

 hcl health care f2f second round interview asked more uestions on microservice 1.apim manage all apis in one place 2.sql profiler in one fo...