Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Querying and modifying data » Querying data » The select list: Specifying columns


Selecting specific columns from a table

You can limit the columns that a SELECT statement retrieves by listing the column(s) immediately after the SELECT keyword. This SELECT statement has the following syntax:

SELECT column-name  [, column-name  ]...
FROM table-name

In the syntax, column-name and table-name should be replaced with the names of the columns and table you are querying.

For example:

SELECT Surname, GivenName
FROM Employees;
 Projections and restrictions
 Rearranging the order of columns