how to get 10 th record from record set using SQL server? there are a lot of code in the internet that can get first 10 results using "TOP" keyword in sql. but i want to get 10th row valus. I'm using VB 2008. please help me....
Regards Pra$ad.
weeraa
0
Light Poster
Recommended Answers
Jump to PostTry this:
select * from (select Row_Number() over (order by [ID]) as RowIndex, * from [DB-Name].[dbo].[Table-Name]) as Sub Where Sub.RowIndex =10
Jump to PostSelect @@rowcount from table where stu_name like ='kevin'
All 7 Replies
GeekByChoiCe
152
Practically a Master Poster
Featured Poster
adam_k
commented:
Agree
+7
weeraa
0
Light Poster
Pgmer
50
Master Poster
Featured Poster
weeraa
0
Light Poster
adam_k
239
Master Poster
Pgmer
50
Master Poster
Featured Poster
weeraa
0
Light Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.