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 program I have to keep every row with
the same 'name' next to each other, with ascending 'part' number. I
don't want to use 'name' as an identifier since they can be long
sentences.
In other words, I have this old table:
SELECT * from table ORDER BY full,part;
name full part score
---- --- --- -----
a 1 1 900
a 1 2 500
b 2 1 800
c 3 1 700
c 3 2 600
c 3 3 500
and I insert these rows into the same table:
(there's nothing I can do about these 'full' values)
d 1 1 1000
d 1 2 400
e 2 1 900
e 2 2 500
f 3 1 700
g 4 1 600
And after some manipulation (that I hope someone can help me with) I
want the query above (SELECT * from table ORDER BY full,part) to give
this:
d 1 1 1000
d 1 2 400
a 2 1 900
e 3 1 900
b 4 1 800
c 5 1 700
c 5 2 600
c 5 3 500
f 6 1 700
g 7 1 600
rather than
a 1 1 900
a 1 2 500
d 1 1 1000
d 1 2 400
b 2 1 800
e 2 1 900
e 2 2 500
c 3 1 700
c 3 2 600
c 3 3 500
f 3 1 700
g 4 1 600
Very grateful for any feedback!
Marcus