Summer Special Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 8w52ceb345

The human resources department wants to know the number of employees who earn $125,000 or...

The human resources department wants to know the number of employees who earn $125,000 or more. However, the department is concerned about duplicates in the dataset. Given the following table:

Employee_ID

Level

Salary

001

1

10000

002

2

20000

003

2

256000

004

2

125000

001

1

10000

002

2

20000

Which of the following SQL statements resolves this issue?

A.

SELECT DISTINCT Employee_ID FROM Employee WHERE Salary >= 125000

B.

SELECT COUNT(DISTINCT Employee_ID) FROM Employee WHERE Salary >= 125000

C.

SELECT DISTINCT Employee_ID FROM Employee WHERE Salary > 125000

D.

SELECT COUNT(Employee_ID) FROM Employee WHERE Salary >= 125000

DA0-002 PDF/Engine
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions
buy now DA0-002 pdf
Get 60% Discount on All Products, Use Coupon: "8w52ceb345"