0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Italian language

select top 50
  OwnerUserId as UserId_1
, body as Texto_1
, ph.UserId as UserId_2
, ph.Text as Texto_2
, case 
  when pts.Body = ph.Text and pts.OwnerUserId <> ph.UserId then 'Yes'
  else 'No' 
  end as Duplicity
 
from Posts pts
 
left join PostHistory ph
on pts.id = ph.PostId
 
where pts.OwnerUserId <> ph.UserId and 
      pts.Body not like '%<%>%'

fork query

edited jan 24 22

created jan 24 22 anonymous