PDA

View Full Version : Sum one column and limit to the eaileir date ...



parscon
12-17-2018, 08:17 AM
Hi ,
I have this SQL code



SELECT
hareketler_siparis_icin_aciklar_birikimli_miktarli.stokid,
hareketler_siparis_icin_aciklar_birikimli_miktarli.markaid,
acik_siparis,
index_teslimat_tarihi
FROM
hareketler_siparis_icin_aciklar_birikimli_miktarli
WHERE
hareketler_siparis_icin_aciklar_birikimli_miktarli.stokid = '7436'
and hareketler_siparis_icin_aciklar_birikimli_miktarli.markaid = '444'
and tipid = 24
and markaid > -1



and the result is

23427
How can i sum the column acik_siparis and also show date 2018-02-09 only ?

Mean

23428

If you can Please help me on this subject . thanks for your effort and your time.

Regards.