Hi,
suppose I have a data of stocks with dates and prices:
Stock
|
Date
|
Price
|
A
|
2009
|
10
|
A
|
2010
|
12
|
B
|
2007
|
20
|
B
|
2008
|
22
|
B
|
2009
|
23
|
C
|
2009
|
6
|
C
|
2010
|
6
|
What I would like to do is to have a selection process each individual stock is either entirely deleted or left based on 2 criteria:
The max year should be greater or equal to 2010 and the max price should be greater or equal to 8.
For the above data only stock A passes the 2 criteria,
so the "want" table should be:
Stock
|
Date
|
Price
|
A
|
2009
|
10
|
A
|
2010
|
12
|
Thank you!!!