[ bokini @ 06.09.2003. 05:33 ] @
Zdravo

Znam da u MySQL-u mogu da uradim nesto poput

SELECT SUM(cena) as c, SUM(porez) as p, SUM(transport) as t FROM artikli

Da li je moguce nesto slicno ovome:

SELECT SUM(cena) as c, SUM(porez) as p, SUM(transport) as t, c + p + t FROM artikli

umesto

SELECT SUM(cena), SUM(porez), SUM(transport), SUM(cena) + SUM(porez) + SUM(transport) as t FROM artikli

pokusavao sam to i izgleda da nije takva sintaksa, a verujem da to postoji

Dakle da se skrati duzina upita, plus verujem i da se ubrza upit

Pozdrav i hvala
Bojan
[ arsa x @ 07.09.2003. 00:24 ] @
SELECT SUM(a) as aa, SUM(b) as bb, SUM(a + b) as cc FROM tbl
:)
Ovo verovatno daje iste rezultate.
Mozes i programski kasnije da saberes aa i bb.

Mada nisam siguran da u tvom query mysql racuna dvaput SUM(....