select records by a particular month wise in sql
You could use a WHERE clause to filter the desired rows:

SELECT   TOP (10) [CUSTOMERID], 
         CONVERT(VARCHAR(20), [ENTRYTRIPDATETIME], 101) AS DATEPART,
         CONVERT(VARCHAR(20), [ENTRYTRIPDATETIME], 108) AS TIMEPART
FROM     [TP_CUSTOMERTRIPS]
WHERE    YEAR([ENTRYTRIPDATETIME]) = 2017
AND      MONTH([ENTRYTRIPDATETIME]) = 2
GROUP BY [CUSTOMERID],[ENTRYTRIPDATETIME] 
HAVING   COUNT(*) &gt; 2;




CUSTOMERID | DATEPART   | TIMEPART
---------: | :--------- | :-------
  20124122 | 02/01/2017 | 02:47:01
  20108092 | 02/10/2017 | 00:37:09



db&lt;>fiddle here

Or use a range of dates:

SELECT   TOP (10) [CUSTOMERID], 
         CONVERT(VARCHAR(20), [ENTRYTRIPDATETIME], 101) AS DATEPART,
         CONVERT(VARCHAR(20), [ENTRYTRIPDATETIME], 108) AS TIMEPART
FROM     [TP_CUSTOMERTRIPS]
WHERE    [ENTRYTRIPDATETIME] &gt;= CAST('20170201' AS DATETIME)
AND      [ENTRYTRIPDATETIME] &lt;  CAST('20170301' AS DATETIME)
GROUP BY [CUSTOMERID],[ENTRYTRIPDATETIME] 
HAVING   COUNT(*) &gt; 2;


db&lt;>fiddle here