>> ïÂÎÁÒÕÖÉÌ ÎÁ ÐÏÓÌÅÄÎÅÍ ÂÉÌÄÅ ÔÁËÕÀ ÐÒÏÂÌÅÍÕ, > > îÅ ÚÎÁÀ ÔÁËÏÇÏ. îÅÕÖÅÌÉ ÎÅÌØÚÑ ÎÏÍÅÒ ÓËÁÚÁÔØ ?
Firebird-2.0.0.12236 >> ÅÓÔØ ÚÁÐÒÏÓ >> >> SELECT SUM(P.PAY_SUMMA) >> FROM PAYS P >> WHERE ( P.ABONENT_ID = :ABONENT_ID) >> AND ( P.PAY_DATE < :STARTDATE) >> AND ( P.PAY_DATE >= :SALDO_DATE) >> >> × ÔÁÂÌÉÃÅ ÅÓÔØ ÚÁÐÉÓÉ Ó ÄÁÔÁÍÉ PAY_DATE '28.12.05','29.12.05','28.12.05' >> ÔÁË ×ÏÔ ÐÒÉ ÚÎÁÞÅÎÉÉ ÐÁÒÁÍÅÔÒÁ STARTDATE='01.01.2006' >> ÏÎÉ × ÒÅÚÕÌØÔÁÔ ÎÅ ÐÏÐÁÄÁÀÔ. >> >> ðÒÉ ÉÚÍÅÎÅÎÉÉ ÕÓÌÏ×ÉÑ Ó <, ÎÁ <= ×ÓÅ ÒÁÂÏÔÁÅÔ ÐÒÁ×ÉÌØÎÏ. >> >> ÔÁË, ÐÒÏÓÔÏ ÓÌÕÞÁÊÎÏ ÎÁÒ×ÁÌÓÑ. > > äÁÊ ÐÏÌÎÙÊ DDL ÔÁÂÌÉÃÙ Ó ÉÎÄÅËÓÁÍÉ, ÞÁÓÔØ ÄÁÎÎÙÈ É ÐÌÁÎÙ ÄÌÑ < É <= ÐÏÐÒÏÂÕÀ ×ÙÒÅÚÁÔØ ËÕÓÏË × ÏÔÄÅÌØÎÕÀ ÂÁÚÕ, ÐÏÔÏÍ ×ÙÌÏÖÕ. É ÅÝÅ ÎÅÐÒÁ×ÉÌØÎÏ ÒÁÂÏÔÁÅÔ ÎÅ ÔÏÌØËÏ SUM, ÎÏ É ÐÒÏÓÔÏ ×ÙÂÏÒËÁ. íÁÔÁÛÉÎ á.÷.
