Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Fruit Date Price Flag Price first Price Last
- Apple 6/1/2015 1.4 Yes 1.4 1.9
- Apple 6/2/2015 1.5 Yes 1.4 1.9
- Apple 6/3/2015 2.5 Yes 1.4 1.9
- Apple 6/4/2015 3 Yes 1.4 1.9
- Apple 6/5/2015 1.7 Yes 1.4 1.9
- Apple 6/6/2015 1.9 No 1.4 1.9
- Fruit Date Price Flag Price first Price Last Price Last Flag Yes
- Apple 6/1/2015 1.4 Yes 1.4 1.9 1.7
- Apple 6/2/2015 1.5 Yes 1.4 1.9 1.7
- Apple 6/3/2015 2.5 Yes 1.4 1.9 1.7
- Apple 6/4/2015 3 Yes 1.4 1.9 1.7
- Apple 6/5/2015 1.7 Yes 1.4 1.9 1.7
- Apple 6/6/2015 1.9 No 1.4 1.9 1.7
- last_value(case when Flag = 'Yes' then Price end ignore nulls)
- over (partition by Fruit order by Date ...
Add Comment
Please, Sign In to add comment