1 Answer
- Newest
- Most votes
- Most comments
0
Yeah, I think the potential query could be something like
'select * from cur where min(line_item_usage_start_date) > current_date - 7'
or
'select distinct line_item_resource_id from cur where min(line_item_usage_start_date) > current_date - 7'
or
select * from cur where line_item_resource_id in ( select distinct line_item_resource_id from cur where min(line_item_usage_start_date) > current_date - 7 )
This should give all resources that are only a week old and all details associated.
answered 3 years ago
Relevant content
- asked 4 months ago
- Accepted Answerasked 2 years ago
- asked 2 years ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated a month ago
- AWS OFFICIALUpdated 6 months ago
- AWS OFFICIALUpdated a year ago