How to get latest until date and everything from date in a single SQL query, Sql Server

How to get latest until date and everything from date in a single SQL ...

Language: Layout:

View schema
Execution time: 0,02 sec, rows selected: 2, rows affected: 4, absolute service time: 0,16 sec

edit mode | history

  
CityName
WeatherProviderName
TimeStamp
TempCelcius

1
Sierra Leon
BBC
09.03.2017 19:47:27
30

2
Sierra Leon
CNN
31.12.1988 00:00:00
30

λ

                                      .NET NoSQL database for rapid development