How to fetch first 10 rows in postgresql
How to use FETCH FIRST N ROWS ONLY | ROWNUM IN SQL | FETCH FUNCTION in SQL | SQL ROWNUM FUNCTION
Timecodes:
hey welcome back
in this video we will learn about
how to
fix the number of output rules whenever
we are using
the set command
basically every time it will give us all
the
values in the table
like this
but
we don't want to see all these values we
just wanted to see
initial five values of four values or
ten values
to filter this
we will use two different function
first is fetch
the second is row number
so let us start with the first one that
is
fetch
let's suppose five correct
rows
only
fetch five first five rows only
now after running this
we saw that there are just five values
instead of hundreds of numbers
in just pick the initial file
now
there's another method to
limit this number is
row number
we will take the same example
and
we will use
where
and
that's one number
i can say it should be less than
equal to 7
it means the whole character
the whole
data that can be that will be faced is
total number of rows is 7.
yes
we can see now is it is just 7 values
that has to be fixed
we can change it to 9 also
10 also it depends on our comfort level
thank you for watching these videos
Related queries:
how to get top 10 rows in postgresql
query to fetch first 10 records in postgresql
how to fetch first 10 rows in oracle
how to use fetch first 10 rows in sql
fetch first 10 rows in sql
fetch first 10 rows in sql server
