Re: Is something like this even possible? (Result set ordering of grouped data)

On 2 Oct 2003 at 11:41, Harald Fuchs wrote about Re: Is something like this even possible? (Result > > I think I found a solution. For 4.1: > > SELECT r1.* > FROM mytbl r1, ( > SELECT x1.category, x1.itemid, COUNT(x2.category) AS rank > FROM mytbl x1 > LEFT JOIN mytbl x2 O

Is something like this even possible? (Result set ordering of grouped data)

Hello, I have a table of items that change over time. These items are in a few categories. So my table looks something like the following simple version. +--++--+-+ | category | itemid | timemodified | currentdata | +--++--+--