kurs:histogramm_gehaltsverteilung
Differences
This shows you the differences between two versions of the page.
|
kurs:histogramm_gehaltsverteilung [2013/05/07 14:03] mh created |
kurs:histogramm_gehaltsverteilung [2014/09/10 21:22] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | <code> | ||
| - | select i, coalesce(lpad('*', count(s), '*'), ' ') from ( | ||
| - | select trunc(salary, -3) s from | ||
| - | employees | ||
| - | ) stat right join | ||
| - | (select level*1000 i from dual connect by level <= 25) r | ||
| - | on r.i = stat.s | ||
| - | group by i | ||
| - | order by i | ||
| - | </code> | ||
| - | resultat: | ||
| - | |||
| - | 1000 | ||
| - | 2000 ************************ | ||
| - | 3000 ****************** | ||
| - | 4000 ******* | ||
| - | 5000 * | ||
| - | 6000 ********** | ||
| - | 7000 *********** | ||
| - | 8000 ********* | ||
| - | 9000 ******** | ||
| - | 10000 ****** | ||
| - | 11000 **** | ||
| - | 12000 *** | ||
| - | 13000 ** | ||
| - | 14000 * | ||
| - | 15000 | ||
| - | 16000 | ||
| - | 17000 ** | ||
| - | 18000 | ||
| - | 19000 | ||
| - | 20000 | ||
| - | 21000 | ||
| - | 22000 | ||
| - | 23000 | ||
| - | 24000 * | ||
| - | 25000 | ||
kurs/histogramm_gehaltsverteilung.txt ยท Last modified: 2014/09/10 21:22 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
