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