I have a table like this:
SELECT * FROM old_tab;
id|descr
---
1|aaa
1|aaa
1|bbb
2|ccc
2|bbb
3|ddd
3|ddd
3|eee
3|fff
4|bbb
etc...
And I want a new table where the descr is concatenated
Hi!
I have a problem with getting the order I want on a table after new rows
have been inserted. I try to simplify it...:
I want to have a one-to-one relationship between 'name' and 'full'.
Every 'name' (or'full') have one or more 'parts'. The higher the 'score'
the lower the 'full', but for my p
Hi Richard,
> Just looking at the start of your output, you are missing some rows
> (a/1/1) and have replaced others (a/2/1 isn't in your data).
Yes, that's exactly it. There's no mistake. The only column I need to
update is 'full', by giving every row a new 'full', based on its
'score'. The tri
