Eliminating Duplicate Values

SELECT DISTINCT
 p
FROM Player p
WHERE p.position = ?1

• Data retrieved: The players with the position specified by the query’s parameter.

• Description: The DISTINCT keyword eliminates duplicate values.

  The WHERE clause restricts the players retrieved by checking their position, a persistent field of the Player entity. The ?1 element denotes the input parameter of the query.

• See also: Input Parameters and The DISTINCT Keyword.