Postgresql – How to get the complete path with CTE
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…
Postgresql – Calculate average score
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…
Postgresql – How to remove specific characters from a string in SQL
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…