- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
SELECT
real_day, 1 start_mon, TO_NUMBER(TO_CHAR(LAST_DAY(TO_DATE ('{date}','dd.mm.yyyy')),'dd')) end_mon,
(CASE WHEN d.t1_aup_f IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),1) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),2) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),3) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),4) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),5) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),6) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),7) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),8) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),9) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),10) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),11) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),12) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),13) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),14) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),15) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),16) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),17) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),18) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),19) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),20) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),21) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),22) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),23) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),24) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),25) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),26) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),27) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),28) over (order by d.real_day)) IS NULL THEN (
CASE WHEN (lag(sum(d.t1_aup_f),29) over (order by d.real_day)) IS NULL THEN
lag(sum(d.t1_aup_f),30) over (order by d.real_day )
ELSE (lag(sum(d.t1_aup_f),29) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),28) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),27) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),26) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),25) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),24) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),23) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),22) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),21) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),20) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),19) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),18) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),17) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),16) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),15) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),14) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),13) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),12) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),11) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),10) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),9) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),8) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),7) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),6) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),5) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),4) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),3) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),2) over (order by d.real_day)) END)
ELSE (lag(sum(d.t1_aup_f),1) over (order by d.real_day)) END)
ELSE d.t1_aup_f END) gf_1,
........
daniser 19.07.2016 15:51 # +14
guestinho 19.07.2016 15:56 # −2
Dummy00001 19.07.2016 16:04 # +13
божественный анролл. потому что царский анролл слаб в сравнении.
roman-kashitsyn 19.07.2016 16:19 # +18
j123123 19.07.2016 18:52 # +14
inkanus-gray 19.07.2016 17:22 # +14
kropotor 19.07.2016 17:43 # +13
guest 23.07.2016 20:39 # −4
guesto 16.08.2016 03:47 # −6
курица не птица, мускульщик не БДист
666_N33D135 28.05.2018 21:13 # 0
666_N33D135 28.05.2018 21:15 # 0