LAG test, Sql Server

LAG test

Language: Layout:

View schema
Execution time: 0,02 sec, rows selected: 10, rows affected: 9, absolute service time: 0,22 sec, absolute service time: 0,21 sec

edit mode | history

  
StatusName
PreviousStatus

1
Pending
NULL

2
Started
Pending

3
Finished
Started

4
Running
Finished

5
Started
Running


  
CustomerStatusId
CustomerId
StatusId
StatusName

1
1
1
1
Pending

2
2
1
2
Started

3
3
1
3
Finished

4
4
1
4
Running

5
6
1
2
Started

λ

                                      .NET NoSQL database for rapid development