---
title: "How can I Select data after 7 days interval using SQL Server"  
description: "How can I Select data after 7 days interval using SQL Server"  
author: "Anonymous User"  
published: 2013-10-16  
updated: 2013-10-16  
canonical: https://www.mindstick.com/forum/1688/how-can-i-select-data-after-7-days-interval-using-sql-server  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# How can I Select data after 7 days interval using SQL Server

I have a [table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap) with Date_Interval in that table have two column. How can I [select](https://www.mindstick.com/forum/160534/orderby-then-select-vs-select-then-orderby-performance) id's of 7 [days](https://www.mindstick.com/articles/157271/how-to-get-cloudways-free-trial-for-14-days-free) interval?

My [data](https://www.mindstick.com/articles/13050/salesforce-aiming-to-dominate-predictive-analytics-with-data-science) is:

[date](https://yourviews.mindstick.com/story/3869/propose-day-2024-exciting-date-ideas-for-you-and-your-partner) id

2013-07-01 11

2013-07-02 22

2013-07-03 33

2013-07-04 33

2013-07-05 44

2013-07-06 44

2013-07-07 45

2013-07-08 46

2013-07-09 47

2013-07-10 48

2013-07-11 48

2013-07-12 49

2013-07-13 50

2013-07-14 51

2013-07-15 52

2013-07-16 52

2013-07-17 53

2013-07-18 53

2013-07-19 54

How can I do this [please suggest](https://answers.mindstick.com/qa/43506/please-suggest-the-bathing-date-at-kumbh) me:

date id

2013-07-01 11

2013-07-08 46

2013-07-15 52

Thanks!

## Replies

### Reply by Aaron Douglas

SELECT date,id FROM table1 GROUP BY WEEK('date', 1)


---

Original Source: https://www.mindstick.com/forum/1688/how-can-i-select-data-after-7-days-interval-using-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.