Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in aggregate-functions

MySQL: Select N rows, but with only unique values in one column

date_trunc 5 minute interval in PostgreSQL [duplicate]

How to fetch the first and last record of a grouped record in a MySQL query with aggregate functions?

mysql aggregate-functions

count without group

Two SQL LEFT JOINS produce incorrect result

COUNT CASE and WHEN statement in MySQL

Example of the Scala aggregate function

scala aggregate-functions

in postgres select, return a column subquery as an array?

Aggregate SQL Function to grab only the first from each group

group by first character

Return as array of JSON objects in SQL (Postgres)

How to define and use a User-Defined Aggregate Function in Spark SQL?

Spark SQL replacement for MySQL's GROUP_CONCAT aggregate function

How can I use SUM for bit columns?

DISTINCT ON in an aggregate function in postgres

How to SUM and SUBTRACT using SQL?

Django Aggregation - Expression contains mixed types. You must set output_field

PostgreSQL: running count of rows for a query 'by minute'

GROUP BY and COUNT in PostgreSQL

How to do a count on a union query