Скачать: CL | DM;

По правте пожалуйста этот запрос не правильно делит   Найти похожие ветки 

← →
Sanyok   (2006-11-15 11:53) [0]

По правте плз не правиль делит в чем проблема ненаю

select sp.name,"удель.вых.м/г3" as type, me.name, g.mes,"факт" as fak, sum(k.p2+k.p4+k.p6+k.p8+k.p10+k.p12+k.p14+k.p16+k.p18+k.p20+k.p22+k.p24)/sum(g.p2+g.p4+g.p6+g.p8+g.p10+g.p12+g.p14+g.p16+g.p18+g.p20+g.p22+g.p24) as dayly
  from gaz g, kond k join spr_ms sp on g.kod_ms=sp.kod join mesac me on k.mes=me.kod
  where g.god = :god and g.mes between :a and :b and k.god = :god and k.mes between :a and :b and
  g.kod_ms=k.kod_ms and g.mes=k.mes
  group by g.kod_ms, g.mes
Union
select sp.name,"Газ" as type, me.name, mes, "факт" as fak, sum((g.p2+g.p4+g.p6+g.p8+g.p10+g.p12+g.p14+g.p16+g.p18+g.p20+g.p22+g.p24)) as dayly from gaz as g join spr_ms as sp
on g.kod_ms = sp.kod
join mesac me on mes = me.kod
where god = :god and mes between :a and :b
group by kod_ms, mes  
UNION
select sp.name, "Конденсат" as type, me.name, mes, "факт" as fak, sum((g.p2+g.p4+g.p6+g.p8+g.p10+g.p12+g.p14+g.p16+g.p18+g.p20+g.p22+g.p24)) as dayly from kond as g join spr_ms as sp
on g.kod_ms = sp.kod
join mesac me on mes = me.kod
where god = :god and mes between :a and :b
group by  kod_ms,mes      
ORDER BY  type, mes

---

← →
Плохиш ©   (2006-11-15 12:29) [1]

> Sanyok   (15.11.06 11:53)  
> По правте плз не правиль делит в чем проблема ненаю

Mit welcher Sprache sprechen Sie?

---

← →
ANB ©   (2006-11-15 12:51) [2]

> Sanyok   (15.11.06 11:53)

AVG разве нету в MySQL ?

---

Страницы: 1 вся ветка

Скачать: CL | DM;



Память: 0.45 MB
Время: 0.045 c