Re: can't get the order I want after inserting new rows

Marcus Claesson wrote:
> 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...:

> 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

> 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

> 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

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).

Are you trying to summarise, and if so by what?
Can you explain how you would do this by hand.
Could you provide the actual table definition?

--   Richard Huxton  Archonet Ltd