 |
|
|
|
 |
|
|
|
 |
|
|
Snippet Name: Frequency Distribution
Description: Returns the frequency of a a given value in a set of values.
Also see:
» RANK
» REGR_SLOPE
» VARIANCE
» VAR_SAMP
» VAR_POP
» SUM
» STDDEV_SAMP
» STDDEV_POP
» STDDEV
» ROW_NUMBER
» REGR_SYY
» REGR_SXY
» REGR_SXX
» REGR_R2
» REGR_INTERCEPT
» REGR_COUNT
» REGR_AVGY
» REGR_AVGX
» Number Functions: RATIO_TO_REPORT
» Number Functions: RANK
» PERCENTILE_DISC
» PERCENTILE_CONT
» PERCENT_RANK
» OVER PARTITION BY
» NTILE
» MIN
» MAX
» LEAD
» LAST_VALUE
» LAST
Comment: (none)
Language:
Highlight Mode: PLSQL
Last Modified: March 01st, 2009
|
CREATE TABLE products (
prod1 NUMBER(3),
prod2 NUMBER(3),
prod3 NUMBER(3));
INSERT INTO products VALUES (34,23,45);
INSERT INTO products VALUES (34,22,34);
INSERT INTO products VALUES (54,44,45);
INSERT INTO products VALUES (23,22,45);
INSERT INTO products VALUES (45,22,34);
SELECT prod1, COUNT(prod1) OVER (PARTITION BY prod1) freq1,
prod2, COUNT(prod2) OVER (PARTITION BY prod2) freq2,
prod3, COUNT(prod3) OVER (PARTITION BY prod3) freq3
FROM products; |
|
|
|
|
|
|
|