SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE [TP_CUSTOMERTRIPS]
(
    ID INT IDENTITY PRIMARY KEY,
    CUSTOMERID INT NOT NULL,
    ENTRYTRIPDATETIME DATETIME NOT NULL
)
INSERT INTO [TP_CUSTOMERTRIPS] VALUES 
(20063381,    '2016-12-08 00:24:35.000'),
(20010438,    '2016-12-16 22:16:55.000'),
(20015278,    '2017-01-28 05:18:20.000'),
(20108092,    '2017-02-10 00:37:09.000'),
(20013275,    '2017-01-06 07:42:05.000'),
(20018833,    '2017-01-27 04:53:32.000'),
(20113994,    '2017-01-27 01:13:44.000'),
(20199820,    '2017-01-27 05:34:24.000'),
(20124122,    '2017-02-01 02:47:01.000'),
(20240710,    '2017-03-21 13:02:18.000'),
(20063381,    '2016-12-08 00:24:35.000'),
(20010438,    '2016-12-16 22:16:55.000'),
(20015278,    '2017-01-28 05:18:20.000'),
(20108092,    '2017-02-10 00:37:09.000'),
(20013275,    '2017-01-06 07:42:05.000'),
(20018833,    '2017-01-27 04:53:32.000'),
(20113994,    '2017-01-27 01:13:44.000'),
(20199820,    '2017-01-27 05:34:24.000'),
(20124122,    '2017-02-01 02:47:01.000'),
(20240710,    '2017-03-21 13:02:18.000'),
(20063381,    '2016-12-08 00:24:35.000'),
(20010438,    '2016-12-16 22:16:55.000'),
(20015278,    '2017-01-28 05:18:20.000'),
(20108092,    '2017-02-10 00:37:09.000'),
(20013275,    '2017-01-06 07:42:05.000'),
(20018833,    '2017-01-27 04:53:32.000'),
(20113994,    '2017-01-27 01:13:44.000'),
(20199820,    '2017-01-27 05:34:24.000'),
(20124122,    '2017-02-01 02:47:01.000'),
(20240710,    '2017-03-21 13:02:18.000');
30 rows affected

SELECT * FROM [TP_CUSTOMERTRIPS];


ID
CUSTOMERID
ENTRYTRIPDATETIME


1
20063381
2016-12-08 00:24:35.000

2
20010438
2016-12-16 22:16:55.000

3
20015278
2017-01-28 05:18:20.000

4
20108092
2017-02-10 00:37:09.000

5
20013275
2017-01-06 07:42:05.000

6
20018833
2017-01-27 04:53:32.000

7
20113994
2017-01-27 01:13:44.000

8
20199820
2017-01-27 05:34:24.000

9
20124122
2017-02-01 02:47:01.000

10
20240710
2017-03-21 13:02:18.000

11
20063381
2016-12-08 00:24:35.000

12
20010438
2016-12-16 22:16:55.000

13
20015278
2017-01-28 05:18:20.000

14
20108092
2017-02-10 00:37:09.000

15
20013275
2017-01-06 07:42:05.000

16
20018833
2017-01-27 04:53:32.000

17
20113994
2017-01-27 01:13:44.000

18
20199820
2017-01-27 05:34:24.000

19
20124122
2017-02-01 02:47:01.000

20
20240710
2017-03-21 13:02:18.000

21
20063381
2016-12-08 00:24:35.000

22
20010438
2016-12-16 22:16:55.000

23
20015278
2017-01-28 05:18:20.000

24
20108092
2017-02-10 00:37:09.000

25
20013275
2017-01-06 07:42:05.000

26
20018833
2017-01-27 04:53:32.000

27
20113994
2017-01-27 01:13:44.000

28
20199820
2017-01-27 05:34:24.000

29
20124122
2017-02-01 02:47:01.000

30
20240710
2017-03-21 13:02:18.000


SELECT   TOP (10) [CUSTOMERID], 
         CONVERT(VARCHAR(20), [ENTRYTRIPDATETIME], 101) AS DATEPART,
         CONVERT(VARCHAR(20), [ENTRYTRIPDATETIME], 108) AS TIMEPART
FROM     [TP_CUSTOMERTRIPS] 
GROUP BY [CUSTOMERID],[ENTRYTRIPDATETIME] 
HAVING   COUNT(*) > 2;


CUSTOMERID
DATEPART
TIMEPART


20063381
12/08/2016
00:24:35

20010438
12/16/2016
22:16:55

20013275
01/06/2017
07:42:05

20113994
01/27/2017
01:13:44

20018833
01/27/2017
04:53:32

20199820
01/27/2017
05:34:24

20015278
01/28/2017
05:18:20

20124122
02/01/2017
02:47:01

20108092
02/10/2017
00:37:09

20240710
03/21/2017
13:02:18

ID	CUSTOMERID	ENTRYTRIPDATETIME
1	20063381	2016-12-08 00:24:35.000
2	20010438	2016-12-16 22:16:55.000
3	20015278	2017-01-28 05:18:20.000
4	20108092	2017-02-10 00:37:09.000
5	20013275	2017-01-06 07:42:05.000
6	20018833	2017-01-27 04:53:32.000
7	20113994	2017-01-27 01:13:44.000
8	20199820	2017-01-27 05:34:24.000
9	20124122	2017-02-01 02:47:01.000
10	20240710	2017-03-21 13:02:18.000
11	20063381	2016-12-08 00:24:35.000
12	20010438	2016-12-16 22:16:55.000
13	20015278	2017-01-28 05:18:20.000
14	20108092	2017-02-10 00:37:09.000
15	20013275	2017-01-06 07:42:05.000
16	20018833	2017-01-27 04:53:32.000
17	20113994	2017-01-27 01:13:44.000
18	20199820	2017-01-27 05:34:24.000
19	20124122	2017-02-01 02:47:01.000
20	20240710	2017-03-21 13:02:18.000
21	20063381	2016-12-08 00:24:35.000
22	20010438	2016-12-16 22:16:55.000
23	20015278	2017-01-28 05:18:20.000
24	20108092	2017-02-10 00:37:09.000
25	20013275	2017-01-06 07:42:05.000
26	20018833	2017-01-27 04:53:32.000
27	20113994	2017-01-27 01:13:44.000
28	20199820	2017-01-27 05:34:24.000
29	20124122	2017-02-01 02:47:01.000
30	20240710	2017-03-21 13:02:18.000

CUSTOMERID	DATEPART	TIMEPART
20063381	12/08/2016	00:24:35
20010438	12/16/2016	22:16:55
20013275	01/06/2017	07:42:05
20113994	01/27/2017	01:13:44
20018833	01/27/2017	04:53:32
20199820	01/27/2017	05:34:24
20015278	01/28/2017	05:18:20
20124122	02/01/2017	02:47:01
20108092	02/10/2017	00:37:09
20240710	03/21/2017	13:02:18