Ïÿòíèöà, 16 ßíâàðÿ 2015 ã. 09:33
+ â öèòàòíèê
Çäðàâñòâóéòå. Â òàáëèöå åñòü ïîëÿ ñîîòâåòñòâóþùèå íîìåðó ìåñÿöà. Ïðè ôîðìèðîâàíèè çàïðîñà ïîëüçîâàòåëü äîëæåí ñàì âûáèðàòü íîìåð íóæíîãî ìåñÿöà, ýòî íóæíî äëÿ òîãî, ÷òîáû â äàëüíåéøåì äîáàâèòü ýòè ñóììû â â ñòîëáåö.
SELECT Date() AS Äàòà, Ðàñøèôðîâêà_2015.ÈÍÍ, Ðàñøèôðîâêà_2015.ÊÖ, Sum(Ðàñøèôðîâêà_2015.[1]) AS Ñóììà
FROM Ðàñøèôðîâêà_2015
GROUP BY Date(), Ðàñøèôðîâêà_2015.ÈÍÍ, Ðàñøèôðîâêà_2015.ÊÖ;
Âìåñòî: Sum(Ðàñøèôðîâêà_2015.[1]) AS Ñóììà íóæíî ÷òî-òî âðîäå: [Ââåäèòå íîìåð ìåñÿöà:], è áóäóò ñóììèðîâàòü ñóììû íåîáõîäèìîãî ìåñÿöà
http://www.sql.ru/forum/1137353/vvesti-nazvanie-stolbca
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-