View Full Version : order by

06-18-2011, 10:41 PM
1 2 4
2 2 10
3 2 5

When I select from this I have to oder by first column
The second col represent a group of records
What I need to is order by third col too, within second column
so the result would be:

1 2 4
2 2 5
3 2 10

I know, select from select .....
but is there something smarter ?

Old Pedant
06-18-2011, 10:56 PM
Umm...are those values all from the same table??

Because what you are asking for is to break apart the records and the re-build them as a completely new set of records.

select from select, or joining one select to another, is only way I see to do something like that.

06-18-2011, 11:09 PM
yes same table, table of hirearchical nested set model.

Will see what I can do.