{"id":2958,"date":"2026-05-07T11:14:03","date_gmt":"2026-05-07T03:14:03","guid":{"rendered":"https:\/\/tekno.bali-island.com\/?p=2958"},"modified":"2026-05-07T11:14:07","modified_gmt":"2026-05-07T03:14:07","slug":"mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql","status":"publish","type":"post","link":"https:\/\/tekno.bali-island.com\/ms\/articles\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\/","title":{"rendered":"Mengenali Fungsi Agregat dan Pengelompokan Data dalam SQL"},"content":{"rendered":"\n<p>Fungsi agregat merupakan subprogram dalam SQL yang menghasilkan satu nilai tunggal apabila dipanggil. Fungsi ini digunakan untuk melakukan pengiraan statistik piawai pada atribut atau medan dalam jadual, seperti mengira jumlah nilai, purata, mencari nilai ekstrem (terkecil\/terbesar), dan mengira bilangan rekod data.<\/p>\n\n\n\n<p>Secara ringkas, fungsi agregat memproses banyak baris data untuk menghasilkan satu nilai output yang ringkas dan informatif.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>1. Jenis-Jenis Fungsi Agregat<\/strong><\/h2>\n\n\n\n<p>Terdapat lima fungsi agregat utama yang sering digunakan dalam pemprosesan data:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>SUM<\/strong>\u00a0Fungsi ini digunakan untuk menjumlahkan semua data pada suatu lajur tertentu. Perlu diingat bahawa fungsi SUM hanya boleh digunakan pada lajur dengan jenis data numerik.\u00a0<strong>Sintaks:<\/strong>\u00a0SELECT SUM(nama_lajur) FROM nama_jadual WHERE syarat;<\/li>\n\n\n\n<li><strong>COUNT<\/strong>\u00a0Fungsi ini digunakan untuk mengira bilangan baris yang terdapat pada suatu lajur. Berbeza dengan SUM, fungsi COUNT boleh berfungsi pada jenis data numerik mahupun bukan numerik (rentetan\/teks).\u00a0<strong>Sintaks:<\/strong>\u00a0SELECT COUNT(nama_lajur) FROM nama_jadual WHERE syarat;<\/li>\n\n\n\n<li><strong>AVG (Purata)<\/strong>\u00a0Fungsi ini digunakan untuk mencari nilai purata bagi suatu lajur. Sama seperti SUM, fungsi ini hanya berfungsi pada jenis data numerik.\u00a0<strong>Sintaks:<\/strong>\u00a0SELECT AVG(nama_lajur) FROM nama_jadual WHERE syarat;<\/li>\n\n\n\n<li><strong>MIN<\/strong>\u00a0Fungsi ini digunakan untuk memaparkan nilai terkecil daripada suatu lajur. Fungsi MIN adalah fleksibel kerana boleh berfungsi pada jenis data numerik dan bukan numerik.\u00a0<strong>Sintaks:<\/strong>\u00a0SELECT MIN(nama_lajur) FROM nama_jadual WHERE syarat;<\/li>\n\n\n\n<li><strong>MAX<\/strong>\u00a0Berlawanan dengan MIN, fungsi ini digunakan untuk memaparkan nilai terbesar daripada suatu lajur. Fungsi ini juga menyokong jenis data numerik dan bukan numerik.\u00a0<strong>Sintaks:<\/strong>\u00a0SELECT MAX(nama_lajur) FROM nama_jadual WHERE syarat;<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>2. Klausa GROUP BY<\/strong><\/h2>\n\n\n\n<p>Klausa&nbsp;<strong>GROUP BY<\/strong>&nbsp;digunakan untuk mengelompokkan data pada satu atau beberapa lajur berdasarkan ekspresi yang dikehendaki. Cara kerjanya adalah dengan mengumpulkan rekod data yang mempunyai nilai yang sama ke dalam satu kumpulan.<\/p>\n\n\n\n<p>Penggunaan klausa ini sangat berkait rapat dengan fungsi agregat, di mana kita sering kali ingin melihat hasil statistik (seperti jumlah atau purata) untuk setiap kategori tertentu.&nbsp;<strong>Sintaks:<\/strong>&nbsp;SELECT nama_lajur FROM nama_jadual GROUP BY nama_lajur;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>3. Klausa HAVING<\/strong><\/h2>\n\n\n\n<p>Klausa&nbsp;<strong>HAVING<\/strong>&nbsp;mempunyai fungsi yang serupa dengan klausa&nbsp;<strong>WHERE<\/strong>, iaitu untuk menambah syarat atau penapis pada hasil pertanyaan. Walau bagaimanapun, terdapat perbezaan asas antara kedua-duanya:<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Pengganti WHERE:<\/strong>\u00a0Klausa WHERE tidak boleh digunakan bersama dengan fungsi agregat. Oleh itu, HAVING digunakan untuk menapis data berdasarkan hasil daripada fungsi agregat tersebut.<\/li>\n\n\n\n<li><strong>Operasi Multi-baris:<\/strong>\u00a0HAVING digunakan pada operasi multi-baris (selepas data dikelompokkan), manakala WHERE berfungsi pada peringkat baris tunggal sebelum data dikelompokkan.<\/li>\n<\/ol>\n\n\n\n<p><strong>Sintaks:<\/strong>&nbsp;SELECT nama_lajur FROM nama_jadual GROUP BY nama_lajur HAVING syarat;<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Fungsi agregat merupakan subprogram dalam SQL yang menghasilkan satu nilai tunggal apabila dipanggil. Fungsi ini digunakan untuk melakukan pengiraan statistik piawai pada atribut atau medan dalam jadual, seperti mengira jumlah nilai, purata, mencari nilai ekstrem (terkecil\/terbesar), dan mengira bilangan rekod data. Secara ringkas, fungsi agregat memproses banyak baris data untuk menghasilkan satu nilai output yang ringkas dan informatif. 1. Jenis-Jenis Fungsi Agregat Terdapat lima fungsi agregat utama yang sering digunakan dalam pemprosesan data: 2. Klausa GROUP BY Klausa&nbsp;GROUP BY&nbsp;digunakan untuk mengelompokkan data pada satu atau beberapa lajur berdasarkan ekspresi yang dikehendaki. Cara kerjanya adalah dengan mengumpulkan rekod data yang mempunyai nilai yang sama ke dalam satu kumpulan. Penggunaan klausa ini sangat berkait rapat dengan fungsi agregat, di mana kita sering kali ingin melihat hasil statistik (seperti jumlah atau purata) untuk setiap kategori tertentu.&nbsp;Sintaks:&nbsp;SELECT nama_lajur FROM nama_jadual GROUP BY nama_lajur; 3. Klausa HAVING Klausa&nbsp;HAVING&nbsp;mempunyai fungsi yang serupa dengan klausa&nbsp;WHERE, iaitu untuk menambah syarat atau penapis pada hasil pertanyaan. Walau bagaimanapun, terdapat perbezaan asas antara kedua-duanya: Sintaks:&nbsp;SELECT nama_lajur FROM nama_jadual GROUP BY nama_lajur HAVING syarat;<\/p>\n","protected":false},"author":1,"featured_media":2944,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[99],"tags":[],"class_list":["post-2958","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-programming"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Mengenali Fungsi Agregat dan Pengelompokan Data dalam SQL<\/title>\n<meta name=\"description\" content=\"Ketahui pengertian fungsi agregat dalam SQL, jenis-jenisnya, serta tutorial penggunaan klausa GROUP BY dan HAVING.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/tekno.bali-island.com\/ms\/articles\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\/\" \/>\n<meta property=\"og:locale\" content=\"ms_MY\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mengenali Fungsi Agregat dan Pengelompokan Data dalam SQL\" \/>\n<meta property=\"og:description\" content=\"Ketahui pengertian fungsi agregat dalam SQL, jenis-jenisnya, serta tutorial penggunaan klausa GROUP BY dan HAVING.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/tekno.bali-island.com\/ms\/articles\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Bali Island Tekno\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/people\/Wilanpedia\/61575048527927\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-05-07T03:14:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-07T03:14:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/AggregateGroup-ByHaving.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Wilan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Wilan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\\\/\"},\"author\":{\"name\":\"Wilan\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#\\\/schema\\\/person\\\/945426dbaeb9dc9d603797b51b1b7e42\"},\"headline\":\"Mengenali Fungsi Agregat dan Pengelompokan Data dalam SQL\",\"datePublished\":\"2026-05-07T03:14:03+00:00\",\"dateModified\":\"2026-05-07T03:14:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\\\/\"},\"wordCount\":422,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/AggregateGroup-ByHaving.webp\",\"articleSection\":[\"Programming\"],\"inLanguage\":\"ms-MY\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\\\/\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\\\/\",\"name\":\"Mengenali Fungsi Agregat dan Pengelompokan Data dalam SQL\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/AggregateGroup-ByHaving.webp\",\"datePublished\":\"2026-05-07T03:14:03+00:00\",\"dateModified\":\"2026-05-07T03:14:07+00:00\",\"description\":\"Ketahui pengertian fungsi agregat dalam SQL, jenis-jenisnya, serta tutorial penggunaan klausa GROUP BY dan HAVING.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\\\/#breadcrumb\"},\"inLanguage\":\"ms-MY\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ms-MY\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/AggregateGroup-ByHaving.webp\",\"contentUrl\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/AggregateGroup-ByHaving.webp\",\"width\":1920,\"height\":1080,\"caption\":\"Aggregate+Group By+Having\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mengenali Fungsi Agregat dan Pengelompokan Data dalam SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#website\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/\",\"name\":\"Bali Island Tekno\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ms-MY\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#organization\",\"name\":\"Bali Island Tekno\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ms-MY\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/Logo-Tekno-Bali-Island.webp\",\"contentUrl\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/Logo-Tekno-Bali-Island.webp\",\"width\":512,\"height\":512,\"caption\":\"Bali Island Tekno\"},\"image\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/people\\\/Wilanpedia\\\/61575048527927\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#\\\/schema\\\/person\\\/945426dbaeb9dc9d603797b51b1b7e42\",\"name\":\"Wilan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ms-MY\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g\",\"caption\":\"Wilan\"},\"sameAs\":[\"https:\\\/\\\/tekno.bali-island.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Mengenali Fungsi Agregat dan Pengelompokan Data dalam SQL","description":"Ketahui pengertian fungsi agregat dalam SQL, jenis-jenisnya, serta tutorial penggunaan klausa GROUP BY dan HAVING.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/tekno.bali-island.com\/ms\/articles\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\/","og_locale":"ms_MY","og_type":"article","og_title":"Mengenali Fungsi Agregat dan Pengelompokan Data dalam SQL","og_description":"Ketahui pengertian fungsi agregat dalam SQL, jenis-jenisnya, serta tutorial penggunaan klausa GROUP BY dan HAVING.","og_url":"https:\/\/tekno.bali-island.com\/ms\/articles\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\/","og_site_name":"Bali Island Tekno","article_publisher":"https:\/\/www.facebook.com\/people\/Wilanpedia\/61575048527927\/","article_published_time":"2026-05-07T03:14:03+00:00","article_modified_time":"2026-05-07T03:14:07+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/AggregateGroup-ByHaving.webp","type":"image\/webp"}],"author":"Wilan","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Wilan","Est. reading time":"3 minit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\/#article","isPartOf":{"@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\/"},"author":{"name":"Wilan","@id":"https:\/\/tekno.bali-island.com\/ms\/#\/schema\/person\/945426dbaeb9dc9d603797b51b1b7e42"},"headline":"Mengenali Fungsi Agregat dan Pengelompokan Data dalam SQL","datePublished":"2026-05-07T03:14:03+00:00","dateModified":"2026-05-07T03:14:07+00:00","mainEntityOfPage":{"@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\/"},"wordCount":422,"commentCount":0,"publisher":{"@id":"https:\/\/tekno.bali-island.com\/ms\/#organization"},"image":{"@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/AggregateGroup-ByHaving.webp","articleSection":["Programming"],"inLanguage":"ms-MY","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/tekno.bali-island.com\/ms\/articles\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\/","url":"https:\/\/tekno.bali-island.com\/ms\/articles\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\/","name":"Mengenali Fungsi Agregat dan Pengelompokan Data dalam SQL","isPartOf":{"@id":"https:\/\/tekno.bali-island.com\/ms\/#website"},"primaryImageOfPage":{"@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\/#primaryimage"},"image":{"@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/AggregateGroup-ByHaving.webp","datePublished":"2026-05-07T03:14:03+00:00","dateModified":"2026-05-07T03:14:07+00:00","description":"Ketahui pengertian fungsi agregat dalam SQL, jenis-jenisnya, serta tutorial penggunaan klausa GROUP BY dan HAVING.","breadcrumb":{"@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\/#breadcrumb"},"inLanguage":"ms-MY","potentialAction":[{"@type":"ReadAction","target":["https:\/\/tekno.bali-island.com\/ms\/articles\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\/"]}]},{"@type":"ImageObject","inLanguage":"ms-MY","@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\/#primaryimage","url":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/AggregateGroup-ByHaving.webp","contentUrl":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/AggregateGroup-ByHaving.webp","width":1920,"height":1080,"caption":"Aggregate+Group By+Having"},{"@type":"BreadcrumbList","@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/mengenali-fungsi-agregat-dan-pengelompokan-data-dalam-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/tekno.bali-island.com\/ms\/"},{"@type":"ListItem","position":2,"name":"Mengenali Fungsi Agregat dan Pengelompokan Data dalam SQL"}]},{"@type":"WebSite","@id":"https:\/\/tekno.bali-island.com\/ms\/#website","url":"https:\/\/tekno.bali-island.com\/ms\/","name":"Bali Island Tekno","description":"","publisher":{"@id":"https:\/\/tekno.bali-island.com\/ms\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/tekno.bali-island.com\/ms\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ms-MY"},{"@type":"Organization","@id":"https:\/\/tekno.bali-island.com\/ms\/#organization","name":"Bali Island Tekno","url":"https:\/\/tekno.bali-island.com\/ms\/","logo":{"@type":"ImageObject","inLanguage":"ms-MY","@id":"https:\/\/tekno.bali-island.com\/ms\/#\/schema\/logo\/image\/","url":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/04\/Logo-Tekno-Bali-Island.webp","contentUrl":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/04\/Logo-Tekno-Bali-Island.webp","width":512,"height":512,"caption":"Bali Island Tekno"},"image":{"@id":"https:\/\/tekno.bali-island.com\/ms\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/Wilanpedia\/61575048527927\/"]},{"@type":"Person","@id":"https:\/\/tekno.bali-island.com\/ms\/#\/schema\/person\/945426dbaeb9dc9d603797b51b1b7e42","name":"Wilan","image":{"@type":"ImageObject","inLanguage":"ms-MY","@id":"https:\/\/secure.gravatar.com\/avatar\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g","caption":"Wilan"},"sameAs":["https:\/\/tekno.bali-island.com"]}]}},"_links":{"self":[{"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/posts\/2958","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/comments?post=2958"}],"version-history":[{"count":1,"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/posts\/2958\/revisions"}],"predecessor-version":[{"id":2959,"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/posts\/2958\/revisions\/2959"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/media\/2944"}],"wp:attachment":[{"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/media?parent=2958"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/categories?post=2958"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/tags?post=2958"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}