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

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Usage » Querying and Modifying Data

 

Querying data

A query requests data from the database and receives the results. This process is also known as data retrieval. All SQL queries are expressed using the SELECT statement. You use the SELECT statement to retrieve all, or a subset of, the rows in one or more tables, and to retrieve all, or a subset of, the columns in one or more tables.


Querying and the SELECT statement
SQL queries
The select list: Specifying columns
The FROM clause: Specifying tables
The WHERE clause: Specifying rows
The ORDER BY clause: Ordering results
Aggregate functions
Full text searching
Text configuration objects
Text indexes
Types of full text searches