Il 21/06/2017 19:11, David G. Johnston ha scritto:
On Wed, Jun 21, 2017 at 9:47 AM, Moreno Andreo wrote:
I have this table
rec_code | rec_date | int1 | int2 |
10 2014-07-21 3 4
11 2014-07-21 5
10 2015-01-04 1 2
11
On Wed, Jun 21, 2017 at 9:47 AM, Moreno Andreo wrote:
> I have this table
>
> rec_code | rec_date | int1 | int2 |
> 10 2014-07-21 3 4
> 11 2014-07-21 5
> 10 2015-01-04 1 2
> 11 2016-02-05 6
>
> That's the result I need
I have this table
rec_code | rec_date | int1 | int2 |
10 2014-07-21 3 4
11 2014-07-21 5
10 2015-01-04 1 2
11 2016-02-05 6
That's the result I need to get from a SELECT statement
rec_date | int1 | int2 | tempvalue
2014-07-21 3 4