10 September 2010

Coding to get nth record in sql server

Coding to get nth record in sql server


for 10 th record

select top 1 * from (select top 10 * from dEmployeenew order by 1 desc)ac

choose 10 with nth

No comments:

Post a Comment

Comments Welcome

Implementing OAuth validation in a Web API

 I mplementing OAuth validation in a Web API Implementing OAuth validation in a Web API using C# typically involves several key steps to sec...