1 個回答
- 最新
- 最多得票
- 最多評論
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.
已回答 4 年前
相關內容
- 已提問 6 個月前
- AWS 官方已更新 3 年前
- AWS 官方已更新 2 年前