Order By, Group By 1

[goodmanrAy]

Hi

Is it possible to Group together fields then order by a different field.
e.g.
I have 2 columns
ID1 - ID2

A - 3
A - 4
A - 5
B - 1
B - 6
C - 2
C - 7

I want to group by ID1 but order by ID2
i.e I want out

B - 1
B - 6
C - 2
C - 7
A - 3
A - 4
A - 5

in that particular order

thanks

Andrew

 

[vongrunt]

Will this work?

select A.* 
from blah A
inner join 
(	select ID1, min(ID2) as minid
	from blah
	group by ID1
) B
on A.ID1=B.ID1
order by B.minid, A.ID2

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[goodmanrAy]

Yep cheers

Andrew