Grup Fonksiyonları

Toplam (sum)

SELECT sum(maas) FROM Personel;
SELECT GrvNo, sum(maas) FROM Personel group by GrvNo;

Ortalama (avg)
SELECT avg(maas) FROM Personel;
SELECT GrvNo, avg(maas) FROM Personel group by GrvNo;

En Düşük (min)
SELECT min(maas) FROM Personel;
SELECT GrvNo, min(maas) FROM Personel group by GrvNo;

En Yüksek (max)
SELECT max(maas) FROM Personel;
SELECT GrvNo, max(maas) FROM Personel group by GrvNo;

Saydırma (count)
SELECT count(*) FROM Personel;
SELECT GrvNo, count(ad) FROM Personel group by GrvNo;

Last modified: Tuesday, 28 November 2017, 2:36 AM