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
SQL-Code.png
How can i sum the column acik_siparis and also show date 2018-02-09 only ?
Mean
SQL-Code-2.png
If you can Please help me on this subject . thanks for your effort and your time.
Regards.