sybase基础知识（国外英文资料）.doc

sybase基础知识（国外英文资料） The general usage of Select is described below by an example. Example 1: select all columns, and the syntax is select * from table_list Select * from publishers Example 2: select the specified column, and the syntax is Select column_name [, column_name]... The from table_name Select pub_id, pub_name from publishers Example 3: rename the column in the query result, the syntax is The select column_heading = column_name The from table_name Select Publisher = pub_name, pub_id The from publishers Example 4: the computation value in the select list can be calculated for the numeric data in the select list, and the arithmetic operator is listed below. Symbolic operation + add - reduction / in addition to * take % modulus For select title_id, total_sales, total_sales * 2 from the title Example 5: use distinct to eliminate duplicate query results Optional keywords eliminate duplicate rows in the results of the select statement. If you do not specify a distinct, the default value is all, and you will retrieve all the row data that contains the duplicate row. Select distinct au_id from titleauthor Example 6: select the line -- where statement The exact specification of which lines to retrieve in the select statement is generally formatted as: Select select_list from table_list where search_conditions The search criteria (or limitations) in the where clause include: The comparison operator (=, , ,! = = Where advance * 2 total_sales * price Scope (between and not between) Where total_sales between 5000 and 10,000 The list (in and not in) Where state in ( CA , in, MD) Match characters (like and not like) Where phone like 0535% Unknown values (is null and is not null) Such as: the where advance is null (and, or) Where advance 5000 or total_sales between 500 and 1000 Example 7: query the result with the collection function summary The collection function USES the data of a particular column to calculate the summary value. The set function is the result Sum is t