Write a SQL query to fetch the Customer who have not done any transaction in last 30 day but did before 30 days
AnswerBot
3mo
SQL query to fetch customers who have not transacted in last 30 days but did before
Use a subquery to filter customers who transacted before 30 days
Use NOT IN or NOT EXISTS to exclude customers who tra...read more
Help your peers!
Add answer anonymously...
Top Insight Global Technologies Azure Data Engineer interview questions & answers
Popular interview questions of Azure Data Engineer
>
Insight Global Technologies Azure Data Engineer Interview Questions
Stay ahead in your career. Get AmbitionBox app
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+
Reviews
4 L+
Interviews
4 Cr+
Salaries
1 Cr+
Users/Month
Contribute to help millions
Get AmbitionBox app