Hi.
I asked a question on this forum about 1 year ago, bu didn't ge an answer then.
Maybe I'm more lucky now?
The question follows:
"Hi.
I have several articles in a database table, written by 5 different writers and at different dates (all writers have written several articles). I want to group all the articles by the writer and each group shall be ordered by date desc.
My query looks at follows:
select writer , date from articles group by writer order by date desc
This will result in the groups being ordered by date desc, but the records inside the groups won't (they will be ordered as standard: the oldes article first).
Does anyone understand me? =)
Please help...
/Martin"
I asked a question on this forum about 1 year ago, bu didn't ge an answer then.
Maybe I'm more lucky now?
The question follows:
"Hi.
I have several articles in a database table, written by 5 different writers and at different dates (all writers have written several articles). I want to group all the articles by the writer and each group shall be ordered by date desc.
My query looks at follows:
select writer , date from articles group by writer order by date desc
This will result in the groups being ordered by date desc, but the records inside the groups won't (they will be ordered as standard: the oldes article first).
Does anyone understand me? =)
Please help...
/Martin"