Data for a specific date

building reports desktopintelligence
1

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)

2

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 :us: (BOB member since 2002-08-20)

3

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)

4

Result:
Date, Score, Min(Date_Score) in Report, Max(Date_Score ) in Report

try those syntax

bonotatsujin :taiwan: (BOB member since 2017-12-20)