Forum Discussion

Copper Contributor

Mar 27, 2022

Window function

Hi Everyone, Can I use windows function in case statement after THEN keyword

Bronze Contributor

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

Copper Contributor

Mar 28, 2022

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

Thanks

olafhelper
Bronze Contributor
Mar 28, 2022
Neha11 that screenshots/photos are useless.
Please post table design as DDL, some sample data as DML statement and the expected result.