Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

sql query for get next 3 and previous 3 records only

Home
Forums
Learn iOS Programming

sql query for get next 3 and previous 3 records only

Paul Rajs

Paul Rajs

8yAsked May 21, 2018, 4:01 AM642Learn iOS Programming

hi developers ,

i want to get the next 3 records and next previous records.

there is two buttons is there on my web page . if user click the next button means it will get next nearby three records .

if the user click the previous button means it will get previous nearby three records .

thanking you

Paul.S

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Sankara Krishnan Venugopal8y ago
Hi Paul,

;WITH PagingCte AS
(
SELECT
(employee_id),
RowNum = ROW_NUMBER() OVER (ORDER BY employee_id)
FROM
dbo.Table_name
)
SELECT
(employee_id)
FROM
PagingCte
WHERE
RowNum BETWEEN 1 AND 3

Update the from and TO in between keyword.
I hope this hepls.