Other News

Community

Party of One

(Bonnie Baker) One of the questions folks ask me is, “How can I get just one row out of DB2 when I know that many rows will qualify for my SQL statement?” In this column I will discuss the different ways you can make this happen in DB2 for OS/390 and, more importantly, the performance differences an

Community

Aggregate Functions

Aggregate functions perform a calculation on a set of values and return a single value. With the exception of COUNT, aggregate functions ignore null values. Aggregate functions are often used with the GROUP BY clause of the SELECT statement.

Community

IDUG 2004 – North America

IDUG 2004 – North America features one of the most comprehensive technical programs dedicated to the DB2 professional. The conference focuses on continual learning, where you can gain insightful, relevant information concerning DB2 and topics such as Autonomic Computing and SMARTer databases, how yo