Hi,
I have a table with articles which have been bought during this year. The structure is:
Number_art, description,discount
Now in this table the article can be there in several lines. What I want to achieve is to get as a result
Number_art, description,discount1,discount2
Where discount1 is the latest discount and discount2 is th second latest discount.
Example in data
Table org.
the result should be
getting the data is no problem, but just getting the Discount of the second row and adding it there is getting me a headache..... any help is very welcome!!!
thx
Johny
I have a table with articles which have been bought during this year. The structure is:
Number_art, description,discount
Now in this table the article can be there in several lines. What I want to achieve is to get as a result
Number_art, description,discount1,discount2
Where discount1 is the latest discount and discount2 is th second latest discount.
Example in data
Table org.
Code:
1234 VHS 10
1234 VHS 5
1234 VHS 11
2222 VCR 5
2223 BETA 10
2223 BETA 5
the result should be
Code:
1234 VHS 10 5
2222 VCR 5
2223 BETA 10 5
getting the data is no problem, but just getting the Discount of the second row and adding it there is getting me a headache..... any help is very welcome!!!
thx
Johny