This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
summary [2017/08/15 08:50] dmtolpeko |
summary [2017/08/19 19:49] dmtolpeko |
||
---|---|---|---|
Line 11: | Line 11: | ||
<code language=sql> | <code language=sql> | ||
SUMMARY [TOP num] FOR table_name [WHERE condition] [LIMIT num] | select_statement; | SUMMARY [TOP num] FOR table_name [WHERE condition] [LIMIT num] | select_statement; | ||
+ | </code> | ||
+ | |||
+ | **Examples** | ||
+ | |||
+ | Summary for a query result: | ||
+ | |||
+ | <code language=sql> | ||
+ | summary for select code, total_emp, salary from sample_07; | ||
+ | </code> | ||
+ | |||
+ | <code> | ||
+ | Column Type Rows NonNull Unique Avg Min Max StdDev p05 p25 p50 p75 p95 | ||
+ | code string 823 823 823 null 00-0000 53-7199 null null null null null null | ||
+ | total_emp int 823 823 806 489748.24 340 134354250 4858790.94 4054.50 17270.00 49335.00 162662.50 1238941.00 | ||
+ | salary int 823 819 759 47963.63 16700 192780 25706.09 21860.00 30547.50 40700.00 58747.50 92025.50 | ||
</code> | </code> | ||
**Version:** HPL/SQL 0.3.31 | **Version:** HPL/SQL 0.3.31 |