I can simply use LAG() to calculate the percentage change from my table (see below) of this month compared to the data 3 months ago or 1 year ago. But now, I want to get this result: calculate the sum…
I have a table like below: ID NextID 1 5 2 NULL 3 6 4 7 5 8 6 9 7 NULL 8 NULL 9 10 10 NULL I want to get the ID path: 1 --> 5 --> 8…
I have a table like this: ID score1 score2 score3 score4 score5 score6 score7 1 6 6 7 7.5 6.5 7 5 2 9 8 7 8 7 8.5 7.5 3 7 7 7 7 7 7 7 I want…
Suppose I have a string in my table, I now want to remove all characters that are the same as the first character (case-insensitive) from that string. For example: uJnMus onsyk uyT Uaszs -> JnMs onsyk yT aszs @uJnMus o@nsyk…