Advertisement
Guest User

Untitled

a guest
Oct 17th, 2019
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.86 KB | None | 0 0
  1. SELECT * FROM (
  2. SELECT * FROM tmp_StatCPRBunker_lohe
  3. UNPIVOT ( BUNKE_COUNT FOR BUNKE_ID IN ( bunke_id_4032,
  4.     bunke_id_4070,
  5.     bunke_id_4205,
  6.     bunke_id_4206,
  7.     bunke_id_4207,
  8.     bunke_id_4208,
  9.     bunke_id_4209,
  10.     bunke_id_4210,
  11.     bunke_id_4211,
  12.     bunke_id_4212,
  13.     bunke_id_4213,
  14.     bunke_id_4214,
  15.     bunke_id_4215,
  16.     bunke_id_4216,
  17.     bunke_id_4217,
  18.     bunke_id_4218,
  19.     bunke_id_4219,
  20.     bunke_id_4220,
  21.     bunke_id_4221,
  22.     bunke_id_4222,
  23.     bunke_id_4223,
  24.     bunke_id_4224,
  25.     bunke_id_4225,
  26.     bunke_id_4226,
  27.     bunke_id_4227,
  28.     bunke_id_4228,
  29.     bunke_id_4234,
  30.     bunke_id_4237,
  31.     bunke_id_4238,
  32.     bunke_id_4239,
  33.     bunke_id_4240,
  34.     bunke_id_4241,
  35.     bunke_id_4242,
  36.     bunke_id_4243,
  37.     bunke_id_4260,
  38.     bunke_id_4261)))
  39.     PIVOT(COUNT(bunke_count) FOR employee IN (pipo,jeje,siat,doje));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement