SQL Tutorial - 24: The TOP and LIMIT Clauses Video Lecture | Microsoft SQL for Beginners - Database Management

hello guys welcome to my channel this is
the twenty-fourth tutorial in this
course in this tutorial we'll be talking
about do clauses the top clause and the
limit clause and both these clauses are
used for the same purpose and the
purpose is to limit the number of
Records that you get in your result set
when you execute a query and the top
Clause is a part of the a and si
standard for SQL and the limit Clause is
the alternative for top in the mine
school environment so there are some
databases that do not allow you to use a
top Clause and MySQL is one such
database and even in Oracle you got row
num as the substitute for talk but you
do not have the top Clause in in Oracle
or MySQL so let's check out how both
these clauses work so as I said the top
Clause is used to fetch you know given
number of records to a query from a
table and you know it makes sense to
have such a thing because you know
sometimes you would be working with
tables that have you know quite a lot of
data like you know thousand rows or five
thousand rows and you know if you would
execute a normal simple select start
query on that table you would get five
thousand rows in your result set and if
suppose you just want to see you know
five or ten sample rows from that table
then you know you can use a top Clause
to limit the number of rows that you get
and first I thought that I should show
you an application of the talk clause
you know by finding in online SQL editor
that allows me to use it but then I
thought that you know since limit is
hardly you know at all different from
top I would you know show you an
application
limit clause in the Maya school
environment so the syntax of top is
pretty simple you got the Select keyword
first and then you type in top and then
the number of records that you want to
see in your result set followed by the
column list and then you type in the
keyword from and the name of the table
and the optional where condition and the
syntax of limit is in fact simpler you
know you've got your regular Select
query first to select column list strong
table name you know optional weight loss
condition and then you know you type in
the keyword limit that's Li MIT and then
the number of rows that you want to see
in your result set and you put semicolon
at the end and execute the query and it
would work perfectly so let's check out
an example of this in the MySQL
environment so I've got my workbench air
and we'll be working with the employee
table in the test database and I will
first execute a regular select star from
query on the table to show you guys you
know the data that's there in the table
at present so as you can see there are a
lot of rows in the table in there are 17
in total now let's say I just want to
see five rows you know not all the rows
in the table so all I have to do is
remove the semicolon at the end type in
the keyword limit and then I'll type in
5 because I want to see five records
output in semicolon at the end of this
and when I execute this query I see that
only five rows are returned this time
right and these five rows are the rows
that appear the at the top in in the
previous query result as well right so
we've just limited the number of rows
that we get in the result set and you
know it's pretty simple there
anything in this to understand so I hope
you guys had fun watching this tutorial
I'll see you in the next one in which we
discuss something interesting important
for sure please subscribe to my channel
in case you haven't already and I see
you soon