Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

First and Last Type and Initial Date Query

Language: Layout:
absolute service time: 0,42 sec 
edit mode |  history
   user type date
1 A Mobile 10.01.2019 00:00:00
2 A Mobile 20.01.2019 00:00:00
3 A Desktop 01.03.2019 00:00:00
4 A Desktop 20.03.2019 00:00:00
5 A Email 01.01.2021 00:00:00
6 A Email 02.01.2020 00:00:00
7 A Desktop 03.01.2021 00:00:00
8 A Desktop 04.01.2021 00:00:00
9 A Desktop 05.01.2021 00:00:00
   user first_type first_type_initial_date last_type last_type_initial_date
1 A Mobile 10.01.2019 00:00:00 Desktop 03.01.2021 00:00:00

    
                
λ
.NET NoSQL database for rapid development