Breaking News: Grepper is joining You.com. Read the official announcement!

mysql grouping functions

Lorenzo Satta Chiris answered on January 14, 2021 Popularity 8/10 Helpfulness 2/10

answer mysql grouping functions

related GROUPING function in mysql

mysql grouping functions

Comment

MySQL Grouping Functions
AVG
MAX
BIT_AND
STD
BIT_OR
STDDEV
COUNT
SUM
GROUP_CONCAT
VARIANCE
MIN

Popularity 8/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: grouping mysql sql

Link to this answer
Share Copy Link

Contributed on Jan 14 2021

Lorenzo Satta Chiris

0 Answers Avg Quality 2/10

Closely Related Answers

GROUPING function in mysql

Comment

/*
The GROUPING function is commonly used to replace 
the nulls that are generated by WITH ROLLUP with literal values. 
The IF function evaluates the expression in the first argument and returns
the second arguments if the expression is true and the third argument if
the expression is false.
#> If you want to display just the summary rows produced by the WITH ROLLUP
operatior, you can include one or more GROUPING functions in the HAVING clause.
*/
SELECT IF(GROUPING(invoice_date) = 1, 'Grand totals', invoice_date) AS invoice_date, 
	   IF(GROUPING(payment_date) = 1, 'Invoice date totals', payment_date) AS payment_date,
	   SUM(invoice_total) AS invoice_total,
	   SUM(invoice_total - credit_total - payment_total) AS balance_due 
FROM invoices
WHERE invoice_date BETWEEN '2018-07-24' AND '2018-07-31'
GROUP BY invoice_date, payment_date WITH ROLLUP;

Popularity 7/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: grouping sql function mysql

Link to this answer
Share Copy Link

Contributed on Oct 13 2022

MazelTov27

0 Answers Avg Quality 2/10

mysql grouping functions

Contents

More Related Answers

mysql grouping functions

Closely Related Answers

GROUPING function in mysql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.