Sayfa
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: Salı, 28 Kasım 2017, 2:36 AM