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

solved 0
ram kumar 2022-03-30T20:14:21+05:30 4 Answers 31 views Beginner
0

Answers ( 4 )

  2. Deepak Rai
    0
    2022-04-27T04:50:03+05:30
    Reply

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

  4. Deepak Rai
    0
    2022-04-27T04:46:18+05:30
    Reply
    Best answer
  6. HowToManage Devices
    0
    2022-04-01T01:41:07+05:30
    Reply

    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 .