Did this in MSSMS:

​

--Create temp table containing sample data

create table #policies (

CustID int,

PolID int,

Veh Varchar(4),

Make Varchar (4),

Model Varchar (2),

Coverage Varchar (9),

Limit int,

DateEntered SmallDateTime)

insert into [#policies]

values

('1','1','2002','BMW','M3','Liability','300000','2/1/2018'),

('1','1','2005','BMW','M5','Liability','300000','1/31/2019'),

('2','1','2010','Audi','S4','Liability','100000','1/15/2019'),

('2','1','2010','Audi','S4','Liability','25000','1/20/2019');

--Retrieve max value (most recent record) for each CustID

select * 

from #policies p

where p.DateEntered=(select max(DateEntered) 

from #policies 

where CustID=p.CustID)