Skip to content

Query: Find duplicates for Entrepreneurs

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

Tables Referenced

  • Entrepreneurs

Columns Selected

  • Entrepreneurs.[Entrepreneur Company ID]
  • Entrepreneurs.[Entrepreneur ID]
  • Entrepreneurs.[Process Status ID]
  • Entrepreneurs.[First Name]
  • Surname

Where Clause

(((Entrepreneurs.[Entrepreneur Company ID]) In (SELECT [Entrepreneur Company ID]

Order By

Entrepreneurs.[Entrepreneur Company ID]

SQL

SELECT Entrepreneurs.[Entrepreneur Company ID], Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Process Status ID], Entrepreneurs.[First Name], Entrepreneurs.[Surname] FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Entrepreneur Company ID]) In (SELECT [Entrepreneur Company ID]