Forum Discussion

Neha11's avatar
Neha11
Copper Contributor
Mar 27, 2022

Window function

Hi Everyone, Can I use windows function in case statement after THEN keyword
olafhelper's avatar
olafhelper
Bronze Contributor
Mar 28, 2022
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

  • Neha11's avatar
    Neha11
    Copper Contributor
    Mar 28, 2022
    Hi olafhelper,
    I have shared the question and query answer
    Can you please check if it works

    Thanks
    • olafhelper's avatar
      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.

Resources