 Hey everybody, this is Brian. Welcome to the 50 first lamp tutorial. Today we're going to be discussing the order by statement. Now as you can see we are using the My Store database and we have a TBL underscore products for a table and here's our data. Same thing we've used in our previous tutorials. So for now we're going to actually say order by and let's say description. What this will do is actually sort your data. See now it's sorted by description and you can do multiple sorts. So order by description and date added. So if it has the same description it'll then order it by added. It may take a little extra time processing doing some of those things. You can also use the keyword DEC for descending. Notice how it's now descending. Let's do that one. Just prove that it is working here. Now it's descending. You can also add this in with the where statement. Let's see here. So we're just going to simply say where the description is like gun, order by description, descending. Did not like that. I'll help if I spell description right. One of those days. There we go. So there's our description descending. You notice how the primary keys get all jumbled up here. So it's always good to actually know what your primary key is. That way you can always select by your primary key. So that's all for this tutorial. Pretty simple, pretty easy. Just remember order by can be used with select. It can be also used after the where. It allows you to sort your data in ascending or descending fashion and you can order by multiple columns.