Need query to fetch duplicate records

Question

select R.ResourceID,
R.ResourceType,
R.Name,R.SMSUniqueIdentifier,
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

Answers ( 4 )

    0
    2022-04-27T04:50:03+05:30

    Forgot to mention. The query you gave in your question is WQL i believe. It’s not SQL Query.

    0
    2022-04-27T04:46:18+05:30
    Best answer
  1. I think you are defining the same table with different names? Do you this should work? I don’t think so

    1. SMS_R_System as r

    2. SMS_R_System as s1

    3. SMS_R_System as s2

Leave an answer

Sorry, you do not have permission to answer to this question .