Forum Discussion

elmira_mkhyahoocom's avatar
elmira_mkhyahoocom
Copper Contributor
Jul 11, 2023

SQL Query

Hi there, I want to write a query for below question: Write SQL that returns all rows in the customer table that: a) Have joined in the past 4 days b) Have a valid email   Customer Cus...
bake13's avatar
bake13
Icon for Microsoft rankMicrosoft
Jul 12, 2023

Hi elmira_mkhyahoocom --

 

You can use a query similar to the one below to obtain the desired results.  Take care.

SELECT FirstName,LastName,JoinDate,EmailAddress,Mobile 
FROM Customer
WHERE JoinDate > DATEADD(day,-4,GETDATE()) AND EmailValid = 1

Resources