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
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
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
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
This class can help in simplifying most of the validation chores in your UI-intensive apps. The class “wraps” around a TextBox control and traps most of its events, to automatically
The NowCombo control is a multi-columns ComboBox that expands on the DBCombo control. You can use it to select and copy an item from another table in the database. For
The NowCombo control is a multi-columns ComboBox that expands on the DBCombo control. You can use it to select and copy an item from another table in the database. For
LogNTEvent is a class that lets a VB app write directly to the NT event log. The zip file includes a demo project and a sample DLL that contains the
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
n my first article on this subject, I discussed the need to have a healthy dose of paranoia when planning how to protect your systems and information. I also demonstrated