How to find min Value

[gireesh1216]

Hello  Team,

I have data like below. Need to find out the min and max values and display to all the rows based on ID.Help me how to do this?

ID	Value
1	10
1	2o
1	30
2	40
2	50

Output:

ID	Value	Min	Max
1	10	10	30
1	20	10	30
1	30	10	30
2	40	40	50
2	50	40	50

[tresesco · Accepted solution]

Min( total <ID> Value)

Max( total <ID> Value)