update all but newest records of each idx, Sql Server

update all but newest records of each idx

Language: Layout:

View schema
Execution time: 0,03 sec, rows selected: 5, rows affected: 8, absolute service time: 0,17 sec

edit mode | history

  
idx
status
var1
date

1
2
1
cat
17.06.2018 15:41:32

2
3
1
dog
17.06.2018 11:41:32

3
2
0
lamb
17.06.2018 11:41:32

4
2
0
pc
17.06.2018 09:41:32

5
3
0
doll
17.06.2018 09:41:32

λ

                                      .NET NoSQL database for rapid development