Essential Books

Select columns which are named after reserved keywords

suggest change

When a column name matches a reserved keyword, standard SQL requires that you enclose it in double quotation marks: 

SELECT 
    "ORDER",
    ID 
FROM ORDERS

Note that it makes the column name case-sensitive.

Some DBMSes have proprietary ways of quoting names. For example, SQL Server uses square brackets for this purpose: 

SELECT 
    [Order],
    ID 
FROM ORDERS

while MySQL (and MariaDB) by default use backticks: 

SELECT 
    `Order`,
    id 
FROM orders
Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

SELECT:
* SELECT
* Using the wildcard character to select all columns in a query.
* SELECT Using Column Aliases
* Select Individual Columns
* Selecting specified number of records
* Selecting with Condition
* Selecting with CASE
* Select columns which are named after reserved keywords
* Selecting with table alias
* Selecting with more than 1 condition.
* Selecting with Aggregate functions
* Get aggregated result for row groups
* Selection with sorted Results
* Selecting without Locking the table
* Select with condition of multiple values from column
* Select distinct unique values only
* Selecting with null
* Select rows from multiple tables
Table Of Contents