Using Order by / Group by?

[anitalulu]

Hi,

I want to order by the sequence of each id to display.

My table structure is:

id Name seq
---------------------------------
1 abc@yahoo.com 3
1 Cheung 2
1 Anita 1
2 def@yahoo.com 3
2 Leung 2
2 Crystal 1


My expected ResultSet is:

id Name seq
---------------------------------
1 Anita 1
1 Cheung 2
1 abc@yahoo.com 3
2 Crystal 1
2 Leung 2
2 def@yahoo.com 3
.
.
.

Any one can help me?

 

[osjohnm]

Hi

Try this:

select id, name, seq
from (your tablename)
order by id, seq

John

 

[anitalulu]

Thanks