Need query to fetch duplicate records
R.ResourceDomainORWorkgroup,R.Client from SMS_R_System as r
full join SMS_R_System as s1 on s1.ResourceId = r.ResourceId
full join SMS_R_System as s2 on s2.Name = s1.Name
where s1.Name = s2.Name and s1.ResourceId != s2.ResourceId
Above query throws error.
I am getting sms_r_system is invalid.
I need help trying with new views or default query which works for this