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