Answer the question
In order to leave comments, you need to log in
How to write a SQL query like "Client - first connection"?
Hello! I guess that the request is simple, but my head is still empty...
There is a users table, which displays the user and the date of his connection to the conditional service. Some users may connect to this service every day:
userid conndate
1 2021-09-01
2 2021-09-01
3 2021-09-01
4 2021-09-01
1 2021-09-02
2 2021-09-02
5 2021-09-02
3 2021-09-03
4 2021-09-03
6 2021-09-03
userid conndate
1 2021-09-01
2 2021-09-01
3 2021-09-01
4 2021-09-01
5 2021-09-02
6 2021-09-03
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question