As part of development task I have to write a SQL logic for the below 6 scenarios, I have achieved desired result in my query using Case Statement but I want to know is there any other options(ways) where I can write query without using Case Statements to achieve the same result using sub-query or window function?
Table 1 - This table will have User Account Type & Subscription Amount
Table 2 - This table will have User Information.
Note: I'm not is allowed to share my script from this computer. Sorry for that.
- This topic was modified 8 months, 3 weeks ago by windows_mss.
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂