Partition By over Two Columns in Row_Number function, Sql Server

Partition By over Two Columns in Row_Number function

Language: Layout:

View schema
Execution time: 0 sec, rows selected: 6, rows affected: 6, absolute service time: 0,17 sec

latest | history

  
dr
aon_empl_id
hr_dept_id
Transfer_Startdate
Effective_bdate

1
1
0100690
69895
2017-01-01
2017-01-01

2
1
0100690
69895
2017-01-01
2017-01-03

3
1
0100690
69895
2017-01-01
2017-01-04

4
1
0100700
69895
2017-01-01
2017-01-01

5
1
0100700
69895
2017-01-01
2017-01-03

6
1
0100700
69895
2017-01-01
2017-01-04

λ

                                      .NET NoSQL database for rapid development