SHARE
TWEET

Untitled

a guest Oct 21st, 2019 88 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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"));
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top