Skip to content

Query: Qry Get Highest Permanent Staff Number

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

Tables Referenced

  • Submissions

Columns Selected

  • Submissions.[Entrepreneur Company ID]
  • Max(Submissions.[Permanent Staff])

SQL

SELECT Submissions.[Entrepreneur Company ID], Max(Submissions.[Permanent Staff]) FROM [Submissions]