Hi I am using below query for getting 10 days data using query. but i am confused for this query could you please give me suggestion to achieve this requirement.

```
select we.StartDateTime,v.EmailAddress from DE1_webActivity_19FEB as we  
where  DATEDIFF(day, we.StartDateTime, GETDATE())<10 and 
                 v.EmailAddress!='' 

```