Tech Tutorials Database
GeekArticles Microsoft ASP.NET
 

Selecting Records Based on Row Number in SQL

 
Author: aspalliance.com
Category: ASP.NET
Comments (0)

Selecting a record from a database table in SQL based on a certain ordering of the records in a table is a difficult problem. For example selecting the employee with the second highest salary. In this short snippet, Aamod recounts his having been asked this question in an interview and how to solve the problem.

Read More...




Sponsored Links




Read Next: Building Reports using ASP.NET and Crystal Reports - Part 5 - Creating Reports as a Web Service



 

 

Comments



Post Your Comment:

Your Name:*
e-mail ID:(required for notification)*
Image Verification: 
 
 Subscribe