SQL Tutorial - 27: The DISTINCT Keyword Video Lecture | Microsoft SQL for Beginners - Database Management

hello guys welcome to my channel this is
the 27th tutorial in this course and in
this tutorial we are going to talk about
the SQL distinct keyword and the SQL
distinct keyword is used with the Select
query to fetch only unique records from
your tables right so if you've got the
information in you know lots of
different rows and if the if the if the
information is repeated as in you know
let's let's take an example so if you've
got a name field in your table and you
know there are a lot of people who have
the same name and if you just want to
see the unique names that you have in
your table if you do not want to see
names being repeated in your result set
then you use the distinct keyword right
so what i've done is i modified the
values that i had in the salary field of
the employee table which we've been
working and now quite a lot of employees
shared the same salary so i'm going to
show you the result of a normal select
query on the salary field of the
employee table first
and i'll order by on the salary field
the name of the table is employee and
i'll use the order by clause and there
you go you see that the first one two
three four employees have the salary
12,500 and then the next three employees
have the salary 13850 and then you know
one employee's word salary of fourteen
thousand four hundred and then you know
there's also some employee with salary
twenty thousand and then you see the
value twenty two thousand five hundred
repeated a few times and then you know
finally twenty two thousand seven and
fifty s also repeated a few times so if
you just want to see the repeated values
once and the results and you want to
know you know what all salaries you know
are being offered by the company so in
that case all you have to do is type in
the keyword distinct before the name of
the column that you've fished out from
your table right so that's d is di NCT
and when i press control enter now you
see that in the results set i get fewer
records right so I see twelve thousand
five hundred
only once I see 13850 once and I see
14400 once so you know I see all these
entries once so that's what the distinct
keyword is used for and thank you so
much for watching this tutorial I'll see
you in the next one you may subscribe to
my channel if you haven't already and as
usual