Select DISTINCT column values from Input

Akshay Sharma 1

Hi, I have multiple entries in table in a single sec, and I want to fetch the single value only, or we say distinct , is there any way we can do that, because DISTINCT is not allowed in stream analytics query

KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2021-06-01T19:43:41.187+00:00

Hi @Akshay Sharma ,

Following up to check if the below suggestion from @Natiq Rzazade was helpful. If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread.

And, if you have any further query do let us know.
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2021-06-02T16:42:56.947+00:00

Hi @Akshay Sharma ,

We still have not heard back from you. Just wanted to check if the below suggestion was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

1 answer

Natiq Rzazade 1 Reputation point

2021-05-27T12:54:26.023+00:00

You may be use window function with over if it is supported. Example row_number
Please sign in to rate this answer.

0 comments No comments
Sign in to comment