fetch
## How to use FETCH FIRST N ROWS ONLY | ROWNUM IN SQL | FETCH FUNCTION in SQL | SQL ROWNUM FUNCTION

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

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