Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM (
- SELECT * FROM tmp_StatCPRBunker_lohe
- UNPIVOT ( BUNKE_COUNT FOR BUNKE_ID IN ( bunke_id_4032,
- bunke_id_4070,
- bunke_id_4205,
- bunke_id_4206,
- bunke_id_4207,
- bunke_id_4208,
- bunke_id_4209,
- bunke_id_4210,
- bunke_id_4211,
- bunke_id_4212,
- bunke_id_4213,
- bunke_id_4214,
- bunke_id_4215,
- bunke_id_4216,
- bunke_id_4217,
- bunke_id_4218,
- bunke_id_4219,
- bunke_id_4220,
- bunke_id_4221,
- bunke_id_4222,
- bunke_id_4223,
- bunke_id_4224,
- bunke_id_4225,
- bunke_id_4226,
- bunke_id_4227,
- bunke_id_4228,
- bunke_id_4234,
- bunke_id_4237,
- bunke_id_4238,
- bunke_id_4239,
- bunke_id_4240,
- bunke_id_4241,
- bunke_id_4242,
- bunke_id_4243,
- bunke_id_4260,
- bunke_id_4261)))
- PIVOT(COUNT(bunke_count) FOR employee IN (pipo,jeje,siat,doje));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement