October 22, 2024
Chicago 12, Melborne City, USA
SQL

Need a query to find duplicate data


How can I write a query in SQL Server that will return the highlighted rows shown in the pic based off the fact the highlighted rows have RecordData that is essentially contained in the row with the same policy. Any advice or direction would be most appreciated.

enter image description here



You need to sign in to view this answers

Leave feedback about this

  • Quality
  • Price
  • Service

PROS

+
Add Field

CONS

+
Add Field
Choose Image
Choose Video