在Azure Cosmos db(SQL)中查询不同文档的最后数据 [英] Query last data of different documents in Azure Cosmos db (SQL)

问题描述

样本数据:

{age: 20, ts: '00:00'},
{age: 20, ts: '00:01'},
{age: 30, ts: '00:00'},
{age: 30, ts: '00:01'},
{age: 40, ts: '00:00'},
{age: 40, ts: '00:01'},
{age: 40, ts: '00:02'}

预期输出:

[{age: 20, ts: '00:01'},
{age: 30, ts: '00:01'},
{age: 40, ts: '00:02'}]

尝试

SELECT * FROM c where c.age in (20, 30, 40) order by c.ts desc

但是结果选择了所有数据.

But the result selected all data.

推荐答案

请尝试以下操作:

SELECT max(c.ts) as ts, c.age FROM c where c.age in (20, 30, 40) 
Group By c.age

这将提供以下输出:

[
    {
        "ts": "00:02",
        "age": 40
    },
    {
        "ts": "00:01",
        "age": 30
    },
    {
        "ts": "00:01",
        "age": 20
    }
]

这篇关于在Azure Cosmos db(SQL)中查询不同文档的最后数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！