click below
click below
Normal Size Small Size show me how
CIT196 Ch 5 and 6
Terms for CIT196 DB Mgmt Chapters 5 and 6
Term | Definition |
---|---|
subquery | A SELECT statement that's coded within another SQL statement |
Aggregate function | Also called a column function; performs calculation on values in a selected rows. |
Summary query | SELECT statement that includes one or more aggregate functions |
Scalar function | Operates on a single value, and returns a single value |
Functionally Dependent column | Grouping column must be a primary ey of the table that contains the column in the SELECT clause or it must be unique and not allow null values |
Aggregate Window Function | Groups and partitions are not colapsed to a single row like they are when using aggregate functions using GROUP BY |
Window | Consists of all of the rows that are needed to calculate the aggregate value for the current row |
Frame | The number of rows before and after the current row (ROWS) or a range of values based on the value of the current row (RANGE) |
Moving Average | Calculated by adding the value of the current row to the values of zero or more preceding and following rows. |
Named Window | Define using a WINDOW clause and should be coded after the HAVING clause and before the ORDER BY clause, if those clauses are included. |
Peer | Row that has the same value as other rows in the sort column. |
Partition | Concept used by aggregate window function for 'group'. PARTITION BY clause |