Sql Server: Get records from/after specific record/id | ASPMANTRA | Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server AND WCF snippets and tutorial

Sql Server: Get records from/after specific record/id

In this article I am going to explain how to select records after a specific record/Id in sql server.


Description:
I want to get records from a specific record or id. I have created a table Tb_Country and insert some dummy records.


Implementation:

Sql query to get records from specific Id:
I want to get all records from where id is 2.

declare @id int =(select id from dbo.Tb_Country where id=2)
Select * from dbo.Tb_Country where id > = @id


Sql query to get records after specific id:
I want to get all records after where id is 2.

Declare @ID int=2;
;WITH CTE
as
(
  select *, ROW_NUMBER() over (order by (select 0)) as rn
  from dbo.Tb_Country
)

select * from CTE where rn in(select rn + 1 from CTE where id >= @ID);


Post a Comment

[blogger]

MKRdezign

Contact Form

Name

Email *

Message *

Powered by Blogger.
Javascript DisablePlease Enable Javascript To See All Widget