Скачать или смотреть Tutorial SQL Bahasa Indonesia-WITH SUBTITLE||SUBJECT 9 DISTINCT&AGGREGATE (SUM,MAX,MIN,AVG,GROUP BY)

Hello Semua nya,
disini saya ingin berbagi pengalaman saya selama ini dalam membuat query MSSQL, semoga ilmu yang saya bagikan ini bermanfaat yaaaaa....

Pada Subject 9 ini saya ingin membahas mengenai DISTINCT & AGGREGATE (SUM,MAX,MIN,AVG,GROUP BY)

Apabila ada pertanyaan , kritik & saran, silahkan ajukan di kolom komentar
Terima kasih...

COPY SQL FILE :
--SUBJECT : DISTINCT & AGGREGATE (SUM,MAX,MIN,AVG,COUNT,GROUP BY)
--OBJECTIVE :
--1.Memahami Select Distinct
--2.Memahami Aggregate


--MATERI :
SELECT SUM(TotalPayment),Segment FROM msCustomer GROUP BY Segment
SELECT * FROM msCustomer

SELECT MAX(TotalPayment),Segment FROM msCustomer GROUP BY Segment
SELECT MAX(TotalPayment) FROM msCustomer
SELECT * FROM msCustomer

SELECT MIN(TotalPayment),Segment FROM msCustomer GROUP BY Segment
SELECT MIN(TotalPayment) FROM msCustomer
SELECT * FROM msCustomer

SELECT AVG(TotalPayment),Segment FROM msCustomer GROUP BY Segment
SELECT AVG(TotalPayment) FROM msCustomer

SELECT COUNT(*),Segment FROM msCustomer GROUP BY Segment
SELECT COUNT(*) FROM msCustomer
SELECT * FROM msCustomer


#mssql #database #sql #sqlserver #tutorialsql #tutorialsqlbahasaindonesia #tutorialmssqlbahasaindonesia #sqlearn