Which expression yields the desired outcomes?

Data from an Excel file is read into a data table named "dtEmployee", as displayed in the following graphic:

A developer needs to filter the data table to obtain all rows representing employees from the Finance and IT departments with a Salary under 30,000.

Which expression yields the desired outcomes?
A . dtEmployee.Select("([Department]=’IT’ AND [Department]=’Finance’) AND [Salary] < 30000")
B . dtEmployee.Select("[Department]=’IT OR [Department]=’Finance’ OR [Salary] < 30000")
C . dtEmployee.Select("[Department]=’IT’ OR [Department]= ‘Finance’ AND [Salary] < 30000")
D . dtEmployee.Select("([Department]=’IT’ OR [Department]=’Finance’) AND [Salary] < 30000")

View Answer

Answer: D