devxlogo

Get Help

Performing Top-N Queries in Oracle

he task of retrieving the top or bottom N rows from a database table (by salary, sales amount, credit, etc.) is often referred to as a “top-N query.” This task

Simplifying Date Data Entry, Part II

n last month’s article I showed you how to create a calendar page in ASP with pop-up functionality. In this month’s article, I’ll show you how to make your pop-up

Using SQL Server 2000 Recovery Models

n my series of articles, “Paranoid and Proud of It,” I pointed out that systems require different backup strategies, depending on the criticality of the information stored in them. SQL

New PL/SQL Features in Oracle 8i: Part II

n my last article, “New PL/SQL Features in Oracle 8i: Part I“, I described some of the new features in Oracle 8i that extend the power, performance, and flexibility of

All the Changes, All the Time: Part I

his 10-Minute Solution was prompted by a question to the Ask the SQL Pro site regarding how best to capture changes that have occurred in a database. I will address

Paranoid and Proud of It: Part I

t is a natural tendency?and normally a very healthy attitude?to look for the best in any situation, to be optimistic about opportunities and life in general. However, when it comes