A Basic Select Query

SELECT p
FROM Player p

• Data retrieved: All players.

• Description: The FROM clause declares an identification variable named p, omitting the optional keyword AS. If the AS keyword were included, the clause would be written as follows:

  FROM Player AS
   p

  The Player element is the abstract schema name of the Player entity.

• See also: Identification Variables.