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,02 sec, rows selected: 7, rows affected: 7, absolute service time: 0,16 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
2016-01-01
2016-01-01

5
1
0100700
69895
2016-01-01
2016-01-03

6
2
0100700
69896
2017-01-01
2017-01-04

7
2
0100700
69896
2017-01-01
2017-01-04

λ

                                      .NET NoSQL database for rapid development