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.
SELECT Surname, GivenName FROM Employees;
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|