need the result table
Actual Date
Date, Score
1, 10
2, 20
3, 30
4, 40
5, 50
6, 60
7, 70
Result:
Date, Score, MinDate_Score, MaxDate_Score
1, 10, 10, 70
2, 20, 10, 70
3, 30, 10, 70
4, 40, 10, 70
5, 50, 10, 70
6, 60, 10, 70
7, 70, 10, 70
rateesh21 (BOB member since 2018-04-26)
select Date, Score, Min(Score), Max(Score) from some_table?
If that’s not what you’re looking for, perhaps be a little more descriptive in your post.
charlie 
(BOB member since 2002-08-20)
I have a table with Date and Score, how do i get the resultant columns with the score based on Min date and Max Date?
rateesh21 (BOB member since 2018-04-26)
Result:
Date, Score, Min(Date_Score) in Report, Max(Date_Score ) in Report
try those syntax
bonotatsujin 
(BOB member since 2017-12-20)