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?
The correct expression to filter the data table for employees from the Finance and IT departments with a salary under 30,000 is dtEmployee.Select("([Department]='IT' OR [Department]='Finance') AND [Salary] < 30000"). This expression ensures that it checks if the Department is either IT or Finance and, at the same time, the Salary is less than 30,000, which meets the specified criteria.
D - D. dtEmployee.Select("([Department]='IT' OR [Department]='Finance') AND [Salary] < 30000"). Checked in Studio.
D is the right one
"D" should be correct answer.