Using SKIP, FIRST, LIMIT, or MIDDLE as a Column Name

If no integer follows the FIRST keyword, the database server interprets FIRST as a column identifier. For example, if table T has columns first, second, and third, the following query would return data from the column named first:

SELECT first FROM T

3The same considerations apply to the SKIP and LIMIT keywords 3of Dynamic Server, and to the MIDDLE keyword of Extended Parallel Server. 3If no literal integer nor integer variable follows the LIMIT keyword in the 3Projection clause, Dynamic Server interprets LIMIT as a column name. If no 3data source in the FROM clause has a column with that name, the query fails 3with an error.