Chapter 9

  1.  You can combine literals, operators, and built-in functions in countless ways to produce expressions.
  2. constant value such as a string, a number, or a NULL value.
  3. Perform math in your query.
  4. An important concept in mathematics is operator precedence, which means the order of operations. Precedence means that higher-level mathematical operations will be performed first so that multiplication and division are done before addition and subtraction. You can add parentheses around calculations to impact the precedence.
  1. String, numeric, and date.
  2. Converts text to lowercase.
  3. Converts a value into the specified data type.
  4. The query may no longer use the indexes on the table.
  5. STDDEV(column)
  6. Virtual and stored.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.222.196.175