I have a requirement where i need to fetch subscribers who have opened at least one email in the last 5 emails delivered to them. Is there any way to achieve this. I have tried Data Views like _Subsribers and _Sent.
You can try something like this
SELECT r.SubscriberKey, j.EmailName, s.EventDate as SentDate, o.EventDate as OpenDate, FROM [YOUR DATA EXTENSION]r LEFT JOIN _Sent s ON r.SubscriberKey= s.SubscriberKey LEFT JOIN _Job as j ON s.JobID = j.JobID LEFT JOIN _Open o ON s.JobID = o.JobID and s.ListID = o.ListID and s.BatchID = o.BatchID and s.SubscriberID = o.SubscriberID and o.IsUnique = 1 WHERE j.EmailName = 'first email name' OR j.EmailName = 'second email name' OR j.EmailName = 'third email name' OR j.EmailName = 'forth email name' OR j.EmailName = 'fifth email name'