R
R
Rinsewind2016-01-21 20:20:42
MySQL
Rinsewind, 2016-01-21 20:20:42

Why does MySQL output only 48 records?

Good evening!
Why does muscle only output 48 records?
Request:

SELECT YEAR(`DATE`), MONTH(`DATE`), `ORG`, FLOOR(SUM(`PRICE`)), FLOOR(SUM(`IDURATION`)) FROM `calls_n`  GROUP BY `ORG`, MONTH(`DATE`) ORDER BY `DATE`

If you put an offset by date, for example
SELECT YEAR(`DATE`), MONTH(`DATE`), `ORG`, FLOOR(SUM(`PRICE`)), FLOOR(SUM(`IDURATION`)) FROM `calls_n` WHERE  `DATE` >  '2014-01-01' GROUP BY `ORG`, MONTH(`DATE`) ORDER BY `DATE`

other data is displayed, but, again, 48 lines.
Execution time - 0.4...1.5 seconds.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexey Ukolov, 2016-01-21
@Rinsewind

Well, you have a group. 12 months * 4 ORG = 48 lines.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question