Window function

Copper Contributor
Hi Everyone,

Can I use windows function in case statement after THEN keyword
3 Replies
Can I use windows function in case statement after THEN keyword

@Neha11 , sorry, but your question is more then unclearly.

May can you explain it more detailed, what you mean here? May with a little example query?

 

Olaf

Hi olafhelper,
I have shared the question and query answer
Can you please check if it works

Thanks

@Neha11 that screenshots/photos are useless.

Please post table design as DDL, some sample data as DML statement and the expected result.