SQL Server Select the most recent past date if no future date availab, Sql Server

SQL Server Select the most recent past date if no future date availab

Language: Layout:

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

edit mode | history

  
CustId
OrderDate
rownum

1
1
2019-09-01
1

2
1
2016-11-01
2

3
2
2019-07-01
1

4
2
2019-11-01
2

5
3
2017-01-01
1

6
4
2017-01-01
1

7
4
2016-12-01
2

λ

                                      .NET NoSQL database for rapid development