If you need to restrict the number of rows returned in an SQL query in which you are using an aggregate function and a GROUP BY clause, you can use the HAVING clause instead of the WHERE clause.
Author: SSWUG Research
Oracle throws weight behind embeddable DBMSs
(Mark Brunelli) Oracle is putting more resources and energy into the embeddable database management system (DBMS) market. (R)
Using Directory Iterators and MySQL with Adapter Objects with PHP
(Alejandro Gervasio) If you’re a PHP programmer who’s searching for a comprehensive tutorial on how to create adapter classes with PHP 5, them look no further. Welcome to the final installment of the series “Implementing adapter objects with PHP.” Made up of two parts, this series teaches you how to
Hello World, Part 7: DB2 for Linux, UNIX, and Windows
(Claire Hong and Renata Kupresak) Welcome to the seventh tutorial in the “Hello, World! Series”, which provides high-level overviews of various IBM software products. This tutorial introduces you to some basic features and concepts in DB2 for Linux, UNIX and Windows and shows you how to implement a
Master Class Jonathan Lewis Cost Based Optimizer
(Gerwin Hendriksen) A couple of weeks ago I was at a MasterClass from Jonathan Lewis about the Cost Based Optimizer. It was a very interesting two days and I like to give some nice highlights on the masterclass.
What’s Hot for Java
(Christine Law) By now, you’ve probably read a lot about the hybrid engine in DB2 9 for Linux, Unix, and Windows (formerly code-named “Viper”), which facilitates the integration of XML and relational data. You also may have read about the DB2 9 features that speed application development. In this ar
Build an Ajax application using Google Web Toolkit, Apache Derby, and Eclipse, Part 1: The fancy front end
(Noel Rappin) Google Web Toolkit (GWT) is a major step forward in the creation of dynamic JavaScript applications that run in users’ Web browsers. Using GWT, developers can design the user interface (UI) and event model using familiar Java techniques while GWT does the hard work of making the code f
Implement Microsoft DirectX Image Transformation Filters in ASP.NET 2.0
(Scott Lysle) This article describes an easy approach to creating custom web controls used to display Microsoft DirectX Image Transformation filter effects in an ASP.NET 2.0 web page. The article includes a class library containing eleven different controls, each of which demonstrates some aspect of
CodeSnip: How to Read/Write an Image to Database in Binary Format
(Sandeep Acharya) In the world of software development, most of the time we are asked to display some descriptive images to end user at UI. Generally, developers store the images inside the folders as image files and display them at the time of demand. In this case we need to store the physical pa
Taking an ASP.NET 2.0 Application Offline
(John Peterson) Normally the last thing you want is for your web application to be offline. In the 24/7/365 world of the Internet, users expect your site to be available whenever they want to use it. Many of the improvements in the latest versions of ASP.NET and IIS have helped make this goal a real