1

Topic: Sampling per every day of a year

Kind time of days;
Tell how to make, please, request to receive the maximum payments per every day of 2016.
In advance thanks.

2

Re: Sampling per every day of a year

orhideja wrote:

Kind time of days;
Tell how to make, please, request to receive the maximum payments per every day of 2016.
In advance thanks.

Set an example the initial data
(5-10 lines) and expected result.

3

Re: Sampling per every day of a year

orhideja wrote:

to receive the maximum payments per every day of 2016

SELECT date, MAX (payment)
FROM datatable
WHERE YEAR (date) =2016
GROUP BY DATE (date)

4

Re: Sampling per every day of a year

In the initial data there is a column paydate, value and receiver, and paydate only for 4 days this year. . on an output there should be a table and with all days 2016 in which were and there were no payments and in which were - the maximum result has been specified

5

Re: Sampling per every day of a year

orhideja wrote:

on an output there should be a table and with all days 2016 in which were and there were no payments and in which were - the maximum result

has been specified Then generate the reference table with all dates of the period.

6

Re: Sampling per every day of a year

And through select in any way it is impossible?

7

Re: Sampling per every day of a year

orhideja wrote:

And through select in any way it is impossible?

It is possible.
Set an example the initial data
(5-10 lines) and expected result.

8

Re: Sampling per every day of a year

orhideja wrote:

And through select in any way it is impossible?

What exactly? To generate the reference table? So it SELECT th also is generated...