This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
summary [2017/08/19 19:51] dmtolpeko |
summary [2017/08/19 19:53] (current) dmtolpeko |
||
---|---|---|---|
Line 38: | Line 38: | ||
total_emp int 823 823 806 489748.24 340 134354250 4858790.94 4054.50 17270.00 49335.00 162662.50 1238941.00 | 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 | salary int 823 819 759 47963.63 16700 192780 25706.09 21860.00 30547.50 40700.00 58747.50 92025.50 | ||
+ | </code> | ||
+ | |||
+ | Top 3 values for each column in table: | ||
+ | |||
+ | <code> | ||
+ | summary top 3 for sample_07; | ||
+ | </code> | ||
+ | |||
+ | <code> | ||
+ | CODE DESCRIPTION TOTAL_EMP SALARY | ||
+ | 53-7199 1 Aircraft mechanics and service technicians 1 25500 2 null 4 | ||
+ | 00-0000 1 Aircraft cargo handling supervisors 1 9910 2 34220 3 | ||
+ | 11-0000 1 Agricultural workers, all other 1 112300 2 35470 3 | ||
</code> | </code> | ||
**Version:** HPL/SQL 0.3.31 | **Version:** HPL/SQL 0.3.31 |