Fungsi SQL
Dokumentasi lengkap 1002 fungsi SQL untuk berbagai database dengan syntax, parameter, dan contoh penggunaan.
PostgreSQL
183 fungsi
Database open-source yang powerful dan populer
DuckDB
175 fungsi
Database analitik in-process yang cepat
Snowflake
224 fungsi
Cloud data warehouse untuk enterprise
BigQuery
220 fungsi
Data warehouse serverless dari Google Cloud
MySQL
200 fungsi
Database relasional open-source yang populer
Semua Fungsi
Menampilkan 24 dari 1002 fungsi
APPROX_COUNT_DISTINCT
BigQueryEstimates the number of distinct values using the HyperLogLog++ algorithm. Much faster and less resource-intensive than COUNT(DISTINCT) for large datasets.
Tipe hasil:
INT64APPROX_QUANTILES
BigQueryCalculates approximate quantile boundaries from numeric data. Uses an efficient approximate algorithm for large datasets, returning an array with n+1 elements.
Tipe hasil:
ARRAY<T>APPROX_TOP_COUNT
BigQueryReturns the approximate most frequently occurring elements along with their counts. Uses a highly efficient approximate algorithm for large datasets.