On Friday 19 December 2008 19:53:03 有末 清華 wrote: > Hi. Well, I want to output the HTML code from database. And the > HTML code should be order by 'cost' and group_by 'category' > > The database table is like below. > > ----------------------------------------------- > ID Category Name Cost > 0 food banana $1 > 1 food apple $2 > 2 book foo $15 > 3 book foobar $10 > 4 something qwert $5 > 5 something poiuy $7 > 6 anything asdf $8 > ----------------------------------------------- this is order_by (category,cost), no grouping. grouping will be: > food ... > book ... > something ... > anything ... one per group
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---