This article provides a brief SQL How-to on how to summarize data. Most of the examples we provide will be based on the ANSI-SQL 92 standard. Some examples will show features specific to SQL Server 7.
Provides ANSI-SQL solutions to common database query/update tasks. These apply to such relational databases as PostGreSQL, MySQL, Microsoft SQL Server, Oracle, Microsoft Access, SQLite.
Custom programming using Active Server Pages (ASP), Cold Fusion, Java Servlets, Java Server Pages (JSP), Access. Database design and programming T-SQL store procs, SQL - SQL Server 6.5/7.0