Your application connects to a SQL Server database that contains a table called Employees with the following columns:

EmployeeID (int, identity)

EmployeeType (char(1))

EmployeeDate (datetime)

You need to write a query that selects all rows from the table where the EmployeeType value is either C or T. Which statement should you use?

Question

Your application connects to a SQL Server database that contains a table called Employees with the following columns:

You need to write a query that selects all rows from the table where the EmployeeType value is either C or T. Which statement should you use?

Accepted Answer

A. SELECT * FROM Employees

Answer

B. SELECT * FROM Employees

Answer

C. SELECT * FROM Employees

Answer

D. SELECT FROM Employees

Your application connects to a SQL Server database that contains a table called Employees with the following columns: - EmployeeID (int, identity) - EmployeeType (char(1)) - EmployeeDate (datetime)…