Tutorial SQL Bahasa Indonesia-WITH SUBTITLE||SUBJECT 9 DISTINCT&AGGREGATE (SUM,MAX,MIN,AVG,GROUP BY)
Автор: Yogi SQLearn
Загружено: 2021-07-06
Просмотров: 71
Описание:
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
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
