Find starting value and ending value

Accepted answer

Try this it may help you SELECT DISTINCT VALUE, FIRST_VALUE(currencyValue) over(partition by value order by Value) Strated, Last_VALUE(currencyValue) over(partition by Value order by Value) Ended from Min_Max_value Thank you

Jignesh Kumar8y ago

Hi Sai,

Same thing is there in 2012 version. I missed version. I wrote same query for your question which one posted after me by snehal.

Thanks

Jignesh Kumar8y ago

Hi Sai,

First_Value and Last_Value is introduced in SQL 2012. This is the Query For your question.

select distinct value, FIRST_VALUE(currencyValue) over(partition by value order by Value) Strated,

Last_VALUE(currencyValue) over(partition by Value order by Value) Ended from Min_Max_value

CurrencyValue	Value
100	1
200	1
300	1
99	1
123	2
321	2
115	2
34	3
37	3
89	3

Value	Started	Ended
1	100	99
2	123	115
3	34	89