sql - How to use rollup function in oracle -

-

i trying use group rollup oracle function, not getting right.

here data format (l1_proj_id level 1 project id etc.....)

proj_id  hours_charged l1_proj_id  l2_proj_id l3_proj_id     l4_proj_id   -------------------------------------------------------------------------   1100.10         20       1100        1100.10    null           null   1100.11.01      30       1100        1100.11    1100.11.01     null   1100.11.02      40       1100        1100.11    1100.11.02     null   1100.12.01.01   50       1100        1100.12    1100.12.01     1100.12.01.01

i need roll totals , output should 

proj_level  hours_charged   --------------------------   1100            140   1100.10          20   1100.11          70   1100.11.01       30   1100.11.02       40    1100.12          50    1100.12.01       50   1100.12.01.01    50

please, let me know if there other easy way do.

as of can data like... 

select    l1_proj_id,    sum(hours_charged) hours_charged  table   group    l1_proj_id  union    select    l2_proj_id,    sum(hours_charged) hours_charged  table  group    21_proj_id   union   select    l3_proj_id,    sum(hours_charged) hours_charged  table  group    l3_proj_id   union   select    l4_proj_id,    sum(hours_charged) hours_charged  table  group    l4_proj_id

this not use rollup, think might deliver results. in essence, unnest columns rows. should relatively easy scale if content changes.

with levels (   select level id   dual   connect level <= 4 ), all_data (   select     case l.id       when 1 l1_proj_id       when 2 l2_proj_id       when 3 l3_proj_id       when 4 l4_proj_id     end project_id,     t.hours_charged       table t,     levels l ) select   project_id, sum (hours_charged) hours_charged all_data project_id not null group project_id

Comments

Post a Comment

Popular posts from this blog

How to show in django cms breadcrumbs full path? -

-
need advice - how show in breadcrumbs whole path article or page? i've got code: {% ance in ancestors %} <li> {% if not forloop.last %} <a href="{{ ance.get_absolute_url }}">{{ ance.get_menu_title }}</a> {% else %} <span class="active">{{ ance.get_menu_title }}</span> {% endif %} </li> {% endfor %} but shows "home" , current page. how modify show whole path in breadcrumbs? i've found in file menu_tags.py code calls ancestors. @ least there class showbreadcrumbs: class showbreadcrumb(inclusiontag): """ shows breadcrumb node has same url current request - start level: after level should breadcrumb start? 0=home - template: template used render breadcrumb """ name = 'show_breadcrumb' template = 'menu/dummy.html' options = options( argument('start_level', default=0, require...
Read more

php - Invalid Cofiguration - yii\base\InvalidConfigException - Yii2 -

-
Image
i've installed yii2-user module/dektrium yii2-app-basic application command composer require "dektrium/yii2-user:0.9.*@dev" config/console.php return [ . . 'modules' => [ 'gii' => 'yii\gii\module', 'user' => [ 'class' => 'dektrium\user\module', ], ], . . ] config/web.php 'components' => [ . . /* 'user' => [ 'identityclass' => 'app\models\user', 'enableautologin' => true, ], */ 'modules' => [ 'user' => [ 'class' => 'dektrium\user\module', ], ], . . ] after that, run command $ php yii migrate/up --migrationpath=@vendor/dektrium/yii2-user/migrations updating database schema . but, when run http://localhost/mylawsuit/yii/web/index.php?r=u...
Read more

ruby on rails - npm error: tunneling socket could not be established, cause=connect ETIMEDOUT -

-
i have app uses rails framework , implements angularjs part of front end. i have pushed heroku , have heroku toolbelt installed, when try migrate db using "heroku run rake db:migrate" receive following error(s): installing core plugins heroku-cli-addons, heroku-apps, heroku-fork, heroku-git, heroku-local, heroku-run, heroku-status... error installing package. try running again gode_debug=info see more output. ! `run` not heroku command. ! perhaps meant `-h`, `2fa`, `auth`, `join`, `open`, `orgs`, `pg`, `ps` or `rake`. ! see `heroku help` list of available commands. i run command "gode_debug=info heroku run rake db:migrate" , receive error: npm err! darwin 14.5.0 npm err! argv "/users/christopher_pelnar/.heroku/node-v4.2.1-darwin-x64/bin/node" "/users/christopher_pelnar/.heroku/node-v4.2.1-darwin-x64/lib/node_modules/npm/cli.js" "install" "heroku-cli-addons" "heroku-apps" "heroku-fork...
Read more