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?
Previous
Next
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