How to fetch second last row in sql
SQL query to get the second last record from table #sql query#
Timecodes:
hello everyone welcome to you my YouTube
channel VBA automation tutorial point if
you are new on the channel so please
like share and subscribe my YouTube
channel to get the updated videos so
guys in this video we will learn we will
talk about SQL query to get the second
last record from that table right guys
so how would I do that in the SQL so for
this I am going to write a query so here
we have a data from the table Center as
you can see that here we have
uh
10 records in this table so what I want
I want the second last
record that is what id number nine so
how would I do that so for this I'm
fired SQL query select top one star from
select
top two
Stars
from table name table
gender
order by ID descending
foreign
taking it as a new column that is new
tab
order
by
ID
so this is the basically SQL query to
get the second last row from the table
so I am going to execute this query and
show you the
output first you can see the
foreign
now I'm going to execute this query and
show you the output to you guys so here
you can see that I have got the second
last row from the table so guys that's
it that's it for this video if you have
any concerns any doubt right regarding
on this video so write your comment in
the comment box I'll get back to you in
that guide so thank you thanks for the
watching
Related queries:
how to fetch second last record in sql
how to select second last row in sql
how to select second last row in sql server
how to get last two rows in sql
how to select last two rows in sql
how to fetch second row in sql
how to get second last record in oracle sql
how to get second row in sql server
how to select second top row in sql
how to select second 1000 rows in sql
how to fetch nth record in sql
how to select nth row in sql server
