...

View Full Version : order by



BubikolRamios
06-18-2011, 09: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, 09: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.

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

Will see what I can do.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum