CodeSnip: Selecting the nth Record from a Table Using Oracle: ASP Alliance

ASP.NET Tutorials » CodeSnip: Selecting the nth Record from a Table Us...

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 telerik
Learn FarPoint
Learn DevExpress
Examples
ASP.NET 2.0 Examples

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

Other Tutorials
Learn Java
Learn Oracle
Opinion / Editorial
Crystal Reports Alliance

Free Tools
Cache Manager
SimpleCMS

Reviews
Book Reviews
Product Reviews
Expert Advice

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

Community
Developer Jobs
Resource Directory
ASP Email Lists
ASP.NET Email Lists
Whidbey Email Lists
AspAlliance Groups
SQL Email Lists
XML Email Lists
Regular Expressions
MS Communities
CodeWise Communities

Web Hosting
ASP Hosting
Dedicated Servers
FREE Hosting
Shared Hosting
Web Farm Hosting

Print Add To Favorites Email To Friend Rate This Article
CodeSnip: Selecting the nth Record from a Table Using Oracle

page 3 of 3

by Deepankar Sarangi
Feedback

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

Article Contents:

Conclusion

Rownum proves to be to a better option than rowid for finding the nth record of a table.

« (Page 2)

View Entire Article

Article Feedback

Comment:
Title:
Name:
Url:	( Optional )

Please add 8 and 2 and type the answer here:

User Comments

Title: question
Name: sanjeet
Date: 5/27/2008 1:19:09 AM
Comment:
Question: display the 7th record of emp table with using rownum.

Question: delete all duplicate records except one record from emp table as empno. , ename, salary,

Latest Resources
» Cute live support
» Cute Chat for ASP.NET
» Cute Editor for ASP.NET
» Photo Book Web Part
» Ali Abbas

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