Kusto query for ADX

Like (0) Share

Report

Posted on 26 Jul 2023 19:12:36 by felixcheah

I want to query an ADX database, I have successfully tested the query. I want to query the last 10 records for 3 instances in a column. For example, I have a column named country, I want the last 10 records for say "Australia" "New Zealand" and "Japan". 10 records for each country, so 30 records in total, is this possible?

Categories:

General Questions

Dataflows

Connecting to Data

All responses (1)

Answers (0)

hthpowerapper 364 Super User 2024 Season 1 on 26 Jul 2023 at 19:40:02

Like (0)

Report
Re: Kusto query for ADX

I believe this can be acomplished by using a union and take operators...
let country1_data = YourTable | where country == "Australia" | order by YourTimestampColumn desc | take 10; let country2_data = YourTable | where country == "New Zealand" | order by YourTimestampColumn desc | take 10; let country3_data = YourTable | where country == "Japan" | order by YourTimestampColumn desc | take 10; union country1_data, country2_data, country3_data