summary
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
summary [2017/08/10 15:32] dmtolpeko |
summary [2017/08/15 08:50] dmtolpeko |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== SUMMARY Statement ======= | ====== SUMMARY Statement ======= | ||
| - | The SUMMARY statement output the summary statistics for a table or result set. | + | The SUMMARY statement outputs the summary statistics for a table or result set. |
| For each column it includes the data type, number of distinct values, non-NULL rows, mean, median, standard deviation, 5%, 25%, 75% and 95% percentiles, min and max values. | For each column it includes the data type, number of distinct values, non-NULL rows, mean, median, standard deviation, 5%, 25%, 75% and 95% percentiles, min and max values. | ||
| Line 10: | Line 10: | ||
| <code language=sql> | <code language=sql> | ||
| - | SUMMARY FOR table_name [WHERE condition] [LIMIT num] | select_statement; | + | SUMMARY [TOP num] FOR table_name [WHERE condition] [LIMIT num] | select_statement; |
| </code> | </code> | ||
| **Version:** HPL/SQL 0.3.31 | **Version:** HPL/SQL 0.3.31 | ||
Page Tools
