DB Sorting Challenge

Question

I have a table as follows,

A   A  
B   B1  
A   A1  
B   B  
A   A2  
B   B3  
A   A3  
B   B2

My result set should be,

A   A  
A   A1  
A   A2  
A   A3  
B   B  
B   B1  
B   B2  
B   B3

Note: A, A1 are all GUIDs.

I have tried quite a few tricks. Please help me solve this problem.

Are those 2 columns or is it 1 column with a space in the value? — JNK
– JNK, Commented Jul 23, 2010 at 20:19
@user400638: Don't abstract necessary details from the question, and don't use tabs for formatting in the future. — OMG Ponies
– OMG Ponies, Commented Jul 23, 2010 at 20:25
why on earth would you care to sort by a GUID? they are just random values! — KM.
– KM., Commented Jul 23, 2010 at 20:47

monksy · Accepted Answer · 2010-07-23 20:20:33Z

5

I'm assuming that the spaces indicate separate columns.

select * from [Table] order by [column1], [column2]

If each line is a string then doing an order by [column1] should be sufficient.

answered Jul 23, 2010 at 20:20

monksy

14.2k19 gold badges78 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kyle B. · Accepted Answer · 2010-07-23 20:20:12Z

2

Maybe I am missing something, but I figured this would be: ORDER BY Column1, Column2

Perhaps you could explain this further?

answered Jul 23, 2010 at 20:20

Kyle B.

5,7976 gold badges42 silver badges57 bronze badges