General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>>I've got this at the end of my SQL:
>>>>
>>>>ORDER BY metal, amount DESCENDING
>>>>
>>>>It puts it in order by metal, but not by amount. I have no idea why.
>>>>
>>>>Thanks,
>>>>
>>>>Michelle
>>>
>>>does the list look like
>>>
>>>"IRON", 10000
>>>"IRON", 9000
>>>"GOLD", 5000
>>>"GOLD", 3000
>>
>>No, actually. I just realized that the metal (D,G,N) is in order ascending. The amount seems to be in random order.
>>
>>Thanks,
>>
>>Michelle
>
>If you remove the word DESCENDING does that fix the problem? Can you list a sampling of what the order looks like?
I got it working, now. I think this thing is buggy.
metal, amount DESCENDING = metal asc, amount random
metal DESCENDING, amount DESCENDING = metal desc, amount random
1 DESCENDING, 3 DECENDING = Works
1 ASCENDING, 3 DECENDING = Error
1 ASC, 3 DESCENDING = Works
So, finally, I got it in the proper order.
Thanks,
Michelle
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only