Mar 10, 2004 · The IN operator can be used to filter records that match a specified comma-delimited list, or the results of another SQL query. For example: Select employeeId, -- integer (int) FirstName, LastName from Employees Where employeeId IN (1,3,6,7,13) Will return employees from the Employees table where the employeId field equals 1, 3, 6, 7, or 13. Similarly, we could just get employees Bob, Mary, and John using the following query: Knowledge about the RDBMS/No SQL itself, e.g. Microsoft SQL Server or Azure cloud platform, Oracle, Azure Cosmos DB. Knowledge of structured query language (SQL), e.g. SQL/PSM or Transact-SQL.