SQL Tutorial - 25: The ORDER BY Clause Video Lecture | Microsoft SQL for Beginners - Database Management

hello guys welcome to my channel this is
the 25th tutorial in this course and in
this tutorial will be checking out a
very important clause in SQL and this is
the order by clause and it is used to
sort data when you pull out data or
fetch information from tables in
databases right and the order by Clause
as I said you know if you want to sort
data in some order like you know you've
got the fields in your table that have
you know character value so if you want
to sort them in alphabetical order or if
you've got numeric values and you want
to see the highest values first or the
lowest values first if you want to do
such things and you use the order by
clause and the syntax of order by is
pretty simple you know you got your
Select keyword and then column list and
then the from keyword and the name of
the table and then the where condition
is obviously optional that's why it's
there in square brackets and the order
by clause is also optional you know
we've seen quite a lot of applications
in which we've use the Select query but
we haven't used you order by so you know
obviously it's not compulsory to use it
but if you want to sort data you know in
some order then you would have to type
in the keywords order and then buy and
then the names of the columns on which
you want to sort your data and by
default the data is sorted in ascending
order so if you want to see data sorted
in descending order then you would have
to specify that too by typing in the
alphabets de SC and this des C is not
the des C that we use to you know see
the structure of tables and it's
different from describe you know only
when you use it with order by it works
in this way in all of the cases it would
just return the structure of tables to
you so let's check out an application of
the order by clause in the Mayan
environment to sort of understand things
better so I've got my workbench here and
what I'll do is I'll execute a very
simple query involving order by and you
know we'll pull out information from the
employee table that we've been using
over the last few tutorials but we'll
pull out information sorted
you know on the basis of the name field
in alphabetical order so I'll type in
select start and then from employee and
then on the next line I'll type in order
by name and I'll put in a semicolon at
the end and when I execute this query I
see that I get an D at the top of the
table followed by Dave and George and
Howard and Jim and Joe so you must have
noticed that you know if you would put
all these names in in a dictionary then
this is the order in which they would
appear right so the names have been
sorted alphabetically and you know if
you want to reverse the order that is if
you want to see you know the employees
who have their names starting with
alphabets you know des Z or you know the
later alphabets then you would have to
type in des see here and you know we see
that too so next if suppose you want to
you know find out who's the youngest
employee in your company then you know
you ordered by age this time and when I
would press the ctrl enter combination I
would see that Phillip is 20 years old
and is the youngest employee and Michael
is 21 years old
Luke is 23 so you know this time the
results have been sorted on the basis of
the H fields now in this table we've got
few records you know there are 17 rows
in total so I can scroll down and I can
see that Pete has 36 years old and he is
the oldest employee in the organization
but if suppose there are lot of records
and I don't want to scroll down to the
bottom of the result set then you know I
can remove the semi-colon and I can type
in DES the important semicolon back
again and when I execute this query now
I see that at the top of the table I see
P and Pete's age is 36 and P is the
oldest employee and similarly if you
want to see you know the employee that
makes the most money then you can order
by the salary column and you know again
since you want to see the highest value
first you would let the DES C be there
and you can see that Shay
in you know who is 33 years old makes
34,000 you know that's the highest
salary in the table so that's it about
order by I hope you guys had fun
watching this tutorial and in this
course we'll be using ordered by quite a
lot and in case things are not clear to
you then you can you know obviously
comment on the video and I'll try to
reply to your messages and please
subscribe my channel in case you haven't
already and I see you in the next
tutorial