Shared Flashcard Set

Details

Chapter 5
Chapter 5
7
Computer Science
Undergraduate 2
02/07/2013

Additional Computer Science Flashcards

 


 

Cards

Term
Scalar Function
Definition
Operate on a single value and return a single value; Example: UCase(), Now(), etc.
Term
Aggregate Functions
Definition
Perform a calculation on the values ina aset of selected rows, also knmown a comlumn functions
Term
Summary Query
Definition
A SELECT statement that includes aggregate functions
Term
Column Functions
Definition
Another name for aggregate functions, which performs a calculation in the values in a set of selected rows.
Term
GROUP BY
Definition
Groups the rows of a result set based on one or more columns or expressions
Term
HAVING
Definition
Specifies a search condition for a group or an aggregate
Supporting users have an ad free experience!