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;

En son değiştirme: 28 Kasım 2017, Salı, 02:36