sql语法5（SQL syntax 5）.docVIP

sql语法5（SQL syntax 5） BETWEEN... AND operator Determines whether a persons value is within a specific range. This operator can only be used in SQL statements. Expr[Not]BETWEEN value1 AND Value2 Expr Specifies the combination of fields and expressions to be calculated. Value1, Value2 The numerical range specified. Such as: If you want to check out all employees aged 25-30 years from the staff form, you can use the following procedure. SELECT name, age BETWEEN 25, AND 30 FROM staff form; LIKE operands Used to compare a string to another particular string style (pattern) and to filter the record that conforms to the string style. Expression LIKE pattern Expression Use the SQL expression in the WHERE conditional clause. Pattern String style to compare. Such as: If you want to check out all the Li led by name, can use the following formula. Like Li * A variety of examples of LIKE operands: 1, more than one character: (1) a*a Can filter: AA, aBa, aBBBa, can not filter: aBC (2) *ab* Can filter: ABC, AABB, Xab, can not filter: aZb, BAC 2, special characters: A * a Can filter: a*a, can not filter: AAA 3, single character: The a a? Can filter: AAA, A3A, aBa, can not filter: aBBBa 4, a single number: A#a Can filter: a0a, A1A, A2A, can not filter: AAA, a10a 5, character range: A-Z. Can filter: F, P, J, can not filter: 2 - 6, specifies the characters to the external range: A-Z! 7, specify non numeric: 0-9! Can filter: A, a, , ~, can not filter: 0, 1, 9 8, combined structure: A B-M #! Can filter: An9, az0, A99, can not filter: ABC, aj0 SQL digital function 1, AVG: arithmetic mean AVG (expr) Expr Field name or expression. Such as: To calculate the average height of staff over 165 cm, you can use the following SQL statement to complete. SELECT, Avg (height) AS average height FROM clerk form WHERE height 165; 2, COUNT: count the number of records COUNT (expr) Expr Field name or expression. Such as: If you want to count the number of employees in the business department and check