Aggregate
BigQuery
APPROX_TOP_SUM
BigQueryReturns the approximate elements with the highest total weight. Similar to APPROX_TOP_COUNT but ranked by sum of weights rather than count.
Tipe hasil:
ARRAY<STRUCT<value T, sum INT64>>Diperbarui: 13 Jun 2026Syntax
SQL
APPROX_TOP_SUM(expression, weight, number)Parameter
expressionanywajib
The column or expression to group by
weightnumericwajib
The weight value to be summed per group
numberINT64wajib
The number of top values to return
Contoh Penggunaan
Top 5 Products by Revenue
SQL
1 SELECT 2 APPROX_TOP_SUM(product_name, revenue, 5) as top_by_revenue 3 FROM `project.dataset.sales`;
Finds the 5 products with the highest total revenue.
Hasil
| top_by_revenue |
|---|
| [{value: "MacBook Pro", sum: 8750000000}, |
| {value: "iPhone 15", sum: 6520000000}, |
| {value: "iPad Pro", sum: 3450000000}, |
| {value: "iMac", sum: 2890000000}, |
| ... 1 baris lainnya |
Top Customers by Spending
SQL
1 SELECT 2 top_customer.value as customer_id, 3 top_customer.sum as total_spending 4 FROM `project.dataset.transactions`, 5 UNNEST(APPROX_TOP_SUM(customer_id, amount, 10)) as top_customer;
Finds the 10 customers with the highest total spending.
Hasil
| customer_id | total_spending |
|---|---|
| C001234 | 125000000 |
| C005678 | 98500000 |
| C002345 | 87250000 |
Top Categories by Quantity Sold
SQL
1 SELECT 2 region, 3 APPROX_TOP_SUM(category, quantity_sold, 3) as top_categories 4 FROM `project.dataset.regional_sales` 5 GROUP BY region;
Top 3 categories by quantity per region.
Hasil
| region | top_categories |
|---|---|
| Jakarta | [{value: "Electronics", sum: 52000}, ...] |
| Surabaya | [{value: "Fashion", sum: 48000}, ...] |
Pertanyaan Umum tentang APPROX_TOP_SUM
Apa itu fungsi APPROX_TOP_SUM di BigQuery?
Returns the approximate elements with the highest total weight. Similar to APPROX_TOP_COUNT but ranked by sum of weights rather than count. Di BigQuery, fungsi APPROX_TOP_SUM termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.
Bagaimana cara menggunakan APPROX_TOP_SUM di BigQuery?
Gunakan sintaks berikut: APPROX_TOP_SUM(expression, weight, number). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.
Apa nilai yang dikembalikan oleh fungsi APPROX_TOP_SUM?
Fungsi APPROX_TOP_SUM mengembalikan nilai bertipe ARRAY<STRUCT<value T, sum INT64>>. Pastikan tipe data hasil sudah sesuai dengan kebutuhan query atau formula kamu. Jika input mengandung nilai NULL, perilaku fungsi dapat berbeda — selalu periksa dokumentasi untuk memastikan hasilnya sesuai ekspektasi.
Apa saja parameter fungsi APPROX_TOP_SUM?
Fungsi ini memiliki 3 parameter wajib. Parameter yang digunakan: expression (any, wajib): The column or expression to group by; weight (numeric, wajib): The weight value to be summed per group; number (INT64, wajib): The number of top values to return.
Ngulik Langsung
Latihan Langsung →Sudah paham APPROX_TOP_SUM? Latih langsung di browser
Latihan interaktif, langsung di browser.