Hi,
If you want to return recently inserted records there should be a date filter, I assume that you are looking recent insert records for past 1week.
Refer below sample query for the same
Declare @tab table
(
val int,
insertdate datetime
)
insert into @tab
values(100,'2015-11-09 12:23:30.377'),(101,'2015-11-10 12:23:30.377'),(102,'2015-11-11 12:23:30.377'),
(104,'2015-11-12 12:23:30.377'),(105,'2015-11-13 12:23:30.377'),(106,'2015-11-14 12:23:30.377'),
(107,'2015-11-15 12:23:30.377'),(108,'2015-11-16 12:23:30.377')
select * from @tab
where CONVERT(date, insertdate) >=CONVERT(date, GETDATE()-7)