CodeSnip: How to Select the Records from a Table Following a Pattern without Using ROWNUM
page 1 of 4
Published: 14 Apr 2008
In this article Deepankar discusses how to select records from an Oracle 9i table without using ROWNUM. Deepankar provides a detailed analysis of each SQL statement along with the screenshot of the final output.
by Deepankar Sarangi
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 19669/ 47


This code snippet is an extension of my earlier code snip How to select the records from a table following a pattern. There I used ROWNUM to find the even/odd records from the emp table. Current code snip achieves the same functionality even without the use of ROWNUM. This method proves useful when it is asked to avoid the use of ROWNUM.

View Entire Article

User Comments

No comments posted yet.

Product Spotlight
Product Spotlight 

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

©Copyright 1998-2015  |  Page Processed at 11/24/2015 7:12:50 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search