Skip to content

Query: Find duplicates for Engage UUID

Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: Yes

Tables Referenced

  • Engage UUID
  • Engage

Columns Selected

  • UUID
  • [Engage UUID].[REMS ID]
  • Source

Where Clause

((([Engage UUID].[UUID]) In (SELECT [UUID] FROM [Engage UUID] As Tmp GROUP BY [U

Order By

[Engage UUID].[UUID]

SQL

SELECT [Engage UUID].[UUID], [Engage UUID].[REMS ID], [Engage UUID].[Source] FROM [Engage UUID] WHERE ((([Engage UUID].[UUID]) In (SELECT [UUID] FROM [Engage UUID] As Tmp GROUP BY [U