Hi, Please help me to acheive this requirement. Input: id Value 1 100 2 200 3 300 4 400 5 500 Output: id Value Pre Nxt 1 100 0 200 2 200 100 300 3 300 200 400 4 400 300 500 5 500 400 0

SELECT Id, p.VAlue LAG(p.Value) OVER ( ORDER BY p.Id) PreviousValue, LEAD(p.Value) OVER ( ORDER BY p.Id) NextValue FROM table p GO

Hi Sai, Try this it will work. create table previNext(id int , [value] int ) insert into previNext(id,[value]) select 1,100 insert into previNext(id,[value]) select 2,200 insert into previNext(id,[value]) select 3,300 insert into previNext(id,[value]) select 4,400 insert into previNext(id,[value]) select 5,500 select * from previNext select id, ISNULL (LAG([value])OVER ( ORDER BY id ),0) previousVlaue,[value], ISNULL (LEAD([value])OVER ( ORDER BY id ),0) nextVlaue from previNext Output: 1 0 100 200 2 100 200 300 3 200 300 400 4 300 400 500 5 400 500 0

Answers

Finding previous and Next value

Sai Reddy

542

Hi,

Please help me to acheive this requirement.

Input:

id	Value
1	100
2	200
3	300
4	400
5	500

Output:

id	Value	Pre	Nxt
1	100	0	200
2	200	100	300
3	300	200	400
4	400	300	500
5	500	400	0

Answers (2)

Next Recommended Forum

select Original column value where column value changed

Exporting from excel to SQL server

Leaderboard

View all

George

Mohammad Hasan Hosseini

-160

Sangeetha S

-6

View all

Yesterday's leader

George

USA

4.2m

33.9k

Member of the month

Shafaet Hossain

C#, .NET, ASP.NET, Blazor

Dhaka (Bangladesh)

707

9.6k

1.3k

Upcoming events

View all

What is the Actors: Dapr in Action - Ep. 11
.NET Conference 2025

Suggested for you

View all

Alkesh Bijarniya

Avneesh Aryan

Sarathlal Saseendran

Bohdan Stupak

Dhanapal Chandran

Forum Statistics

Please welcome our newest member naman .
3,078,253 users have contributed to 147,418 threads and 483,404
In the past 24 hours, we have 6 new threads, 27 new posts, and 55 new users.
In last week, the most popular thread is 'ItemId is not able to save into the tblQuantities'.