Window function

[Neha11]

Hi Everyone,

Can I use windows function in case statement after THEN keyword

[#2]

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

[#3]

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

Thanks

[#4]

@Neha11 that screenshots/photos are useless.

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