Deltek Talent Management

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Aggregate

You can find definitions for aggregate functions from avgr to variance:

Function Description
avgr Returns the average value of expr.
bit_and Returns the bitwise AND of all bits in expr. The calculation is performed with 64-bit (BIGINT) precision. Returns the bitwise XOR of all bits in expr. The calculation is performed with 64-bit (BIGINT) precision.
bit_or Returns the bitwise OR of all bits in expr. The calculation is performed with 64-bit (BIGINT) precision. Returns the bitwise XOR of all bits in expr. The calculation is performed with 64-bit (BIGINT) precision.
bit_xor Returns the bitwise XOR of all bits in expr. The calculation is performed with 64-bit (BIGINT) precision. Returns the bitwise XOR of all bits in expr. The calculation is performed with 64-bit (BIGINT) precision.
count Returns a count of the number of non-NULL values in the rows retrieved by a SELECT statement. The result is a BIGINT value. COUNT() returns 0 if there were no matching rows.
count_distinct Returns a count of the number of non-NULL distinct values in the rows retrieved by a SELECT statement. The result is a BIGINT value. COUNT() returns 0 if there were no matching rows.'
group_contact Returns a string result with the concatenated non-NULL values from a group. It returns NULL if there are no non-NULL values.
group_contact_distinct Returns a string result with the concatenated non-NULL DISTINCT values from a group. It returns NULL if there are no non-NULL values.
min Returns the minimum value of expr.
max Returns the maximum value of expr.
stddev Returns the population standard deviation of expr (the square root of VAR_POP()).
stddev_samp Returns the sample standard deviation of expr (the square root of VAR_SAMP().
sum Returns the sum of expr. If the return set has no rows, SUM() returns NULL.
var_pop Returns the sum of expr. If the return set has no rows, SUM() returns NULL.
var_samp Returns the sample variance of expr. That is, the denominator is the number of rows minus one.
variance Returns the population standard variance of expr.