A developer is working with an entity User, which has an identity field and a salary field. Which Java Persistence query will return those users with the highest salaries?

Question

Options

• ASELECT u FROM User u WHERE u.salary >= ALL (SELECT d.salary FROM User d)
• BSELECT u FROM User u WHERE u.salary >= ANY (SELECT d.salary FROM User d)
• CSELECT u FROM User u WHERE ALL(u.salary >= (SELECT d.salary FROM User d))
• DSELECT u FROM User u WHERE u.salary >= (SELECT ALL(d.salary) FROM User d)

• A
  80% (32)
• B
  13% (5)
• C
  3% (1)
• D
  5% (2)

No community discussion yet for this question.