CodeSnip: How to Select the Records from a Table Following a Pattern: ASP Alliance

ASP.NET Tutorials » CodeSnip: How to Select the Records from a Table F...

Not Logged In. Login

AspAlliance
Register
Edit My Profile
Author List
Write for Us
About AspAlliance
Contact Us
Privacy Policy
Link To Us
Advertise

Subscribe
Free Newsletter
Newsletter Archive
RSS Syndication

.NET Tutorials
Learn .NET
Learn WCF
Learn WPF
Learn ASP.NET
Learn AJAX
Learn Silverlight
Learn Visual Studio
Learn ADO.NET
Learn LINQ
Learn C# (CSharp)
Learn VB.NET
Learn Web Services
Learn Controls
Learn BizTalk
Learn SharePoint
Learn Mobile
Learn SQL
Learn SQL Reporting
Learn Windows Forms
Learn XML
Learn Crystal Reports
Learn FarPoint
Learn DevExpress
Examples
ASP.NET 2.0 Examples

ASP Tutorials
Learn ASP
Learn VBScript
Learn JScript
Learn SQL
Learn XML

Software Resources
Shopping Cart Ecommerce
Charts and Dashboards

Other Resources
Learn Java
Learn Oracle
Opinion / Editorial
Crystal Reports Alliance
WPF Resources
AJAX Resources
Silverlight Resources

Free Tools
Cache Manager
SimpleCMS

Reviews
Book Reviews
Product Reviews
Expert Advice

Books
ASP.NET Developer's Cookbook
Sample Chapters
Book Reviews

Community
Regular Expressions

Print Add To Favorites Email To Friend Rate This Article
CodeSnip: How to Select the Records from a Table Following a Pattern

page 1 of 4

Published: 28 Feb 2008

Abstract
In this code snippet, Deepankar examines how to select only specific records from a table commencing in a series (even series i.e. 2nd,4th,6th...records or odd series i.e. 1st,3rd,5th.... records and other simple series) in a single query. He provides a detailed analysis of the relevant SQL statements with the help of relevant screenshots.

by Deepankar Sarangi
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 19417/ 91

Article Contents:

Introduction

This code snip explains how to select only those records from a table which follow a particular series. Let us say we want to find only the odd numbered rows from a table.

View Entire Article

(Page 2) »

User Comments

No comments posted yet.

Community Advice: ASP | SQL | XML | Regular Expressions | Windows