1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
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.
répondu il y a 4 ans
Contenus pertinents
- demandé il y a un an
- demandé il y a un an
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans