Facing challenge in creating segment to fetch all the customer who has purchased 'x' product in their last purchase(event/transaction) or most recent purchase. there is no explicit function is available for most recent like others (eg. withing, in last, custom date, rolling range, before etc.) in se...

On your third note of above reply i.e. Fetch the record details of the profile.   I am able to fetch the details of single profile using select query but when I try to delete a profile using delete query It is throwing an error (ErrorCode: 42601 Syntax error encountered. Reason: [Invalid command!]) ...

Using API, I want to do below Get the list of profiles qualified in a segment. Delete a specific profile from this list. Fetch the record details of the profile.  

Can we use queries to fetch segment's all attributes in AEP ?. and I also find some auto suggested table name in Queries like (segment_ingestion_dataset, segment_export_dataset) where does it come from as there is no such dataset present with this names.