Select last 7 days record from current Date in SQL Server

Last Reply 3 months ago By pandeyism

Posted 3 months ago

Suppose today is Friday and i want to get data on every friday.From last Friday to Thursday of every Week. Example: 19-07-2019(Friday) So i want data from 12-07-2019(Friday)-to -18-07-2019(Thurday)

Same process will run every week

ClientID    Name    Country    Amount    Last_Modified_Date 

these are the column on which we want to get data.

 

This question does not have replies that have been liked.