Hudson Benson is the owner of The Cattail Company, a Web and media development company located in northeastern Maryland. His experience includes the development and marketing of Web applications for businesses, universities, and nonprofit organizations. Hudson also serves as North American director of marketing and business development for a global firm headquartered in Sweden.
The DBMS (database management system) is often faster at performing
calculations like summing up or averaging the values in a column of numbers
than, for instance, the application server. However, there are many cases in
which performing the same calculation on all of the data in a column will not
provide the correct result.
This article will show you how to use the CASE expression in SQL queries to
more flexibly perform aggregate calculations and set values based on a
logical statement.
An example of the need to apply the CASE expression in an aggregate function
is an online s... (more)
Hudson Benson is the owner of The Cattail Company, a Web and media development company located in northeastern Maryland. His experience includes the development and marketing of Web applications for businesses, universities, and nonprofit organizations. Hudson also serves as North American director of marketing and business development for a global firm headquartered in Sweden.
Richard Sarwal 
Scott Quint
Nilesh Dabholkar
Barry Fenning
Avon Gibs
Ivo Gonzaga da Silva
Jason Dolinger
Lars Ewe
Stephen Dukker
Irfan Khan
Matt Pollicove
