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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Queries and data modification



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.

To learn more about SQL Anywhere query processing, including query optimization, selectivity estimation, and cost estimation, see the Query Processing Based on SQL Anywhere 12.0.1 Architecture white paper at [external link]

The SELECT statement and querying
Query predicates
SQL queries
The SELECT list: Specifying columns
The FROM clause: Specifying tables
The WHERE clause: Specifying rows
The ORDER BY clause: Ordering results
Indexes that improve ORDER BY performance
Aggregate functions in queries
Advanced: Query processing phases
Advanced: Query optimization
Advanced: Query execution plans
Advanced: Parallelism during query execution