However I want you to notice something a little bit weird here. Now if I run this query it will work in regards to it doesn't throw an error. Then I actually want to sort by revenue and I'll try to do it descending. If I paste this in and say that I want the guides_title but even before that I want to have the guides_revenue. Now I want to show you something that may seem a little weird. So if I run it again now you can see that it is alphabetically sorted. If I were to copy this and sort ascending, It's going to be the same results set.
MYSQL CAST CODE
Now if I run this code you can see that now this is sorted this and it has “something else”, “My Great post”, and “my blog”. So here I'm going to say guides_title and then you say if you want it to be descending or ascending.
So in order to do that we're going to add another line and say “ORDER BY” and then you pick out the parameter that you want to order it by. However, we also have the ability to add a ORDER BY clause which will allow us to sort the data as it comes through and the result set. So if I run this code you can see that it has “my blog”, “something else”, “My Great post”, “my blog”, and “my blog” and that may be fine. The results are going to just sort it by the id that's the default that SQL runs. For example right now if I were to just say SELECT guides_title FROM guides and if I run this query it's going to bring back in all the results. One of the ways it can be formatted is you can see things in a specific order. In many cases when you're working with SQL queries it's very important to have some formatted data when it comes back.
0 kommentar(er)
