• ▼MSDN Library Visual Studio 6.0
  • ▶Welcome to the MSDN Library
  • ▶Visual Studio Documentation
  • ▶Visual Basic Documentation
  • ▶Visual C++ Documentation
  • ▶Visual FoxPro Documentation
  • ▶Visual InterDev Documentation
  • ▶Visual J++ Documentation
  • ▶Visual SourceSafe Documentation
  • ▶Tools and Technologies
  • ▶Microsoft Office Development
  • ▼Platform SDK
    • ▶What's New?
    • ▶Windows Programming Guidelines
    • ▼Database and Messaging Services
      • ▶DAO SDK
      • ▶Microsoft Data Access SDK
      • ▶Microsoft Exchange Server
      • ▶Messaging API (MAPI)
      • ▶Collaboration Data Objects
      • ▶Extending the Microsoft Exchange Client
      • ▼Microsoft SQL Server Programmer's Toolkit
        • ▶What's New in SQL Server 6.5
        • ▶SQL Server Setup
        • ▶Administrator's Companion
        • ▼Database Developer's Companion
          • ▶Before You Begin
          • ▶Overview
          • ▶Chapter 2 Working with Tables
          • ▶Chapter 3 Working with Data
          • ▼Chapter 4 Retrieving Data with Queries
            • ▶Creating Basic Queries
            • ▶Using Joins to Create Multitable Queries
            • Using Summary Queries
            • ▶Using Subqueries
            • ▼Displaying Totals with GROUP BY or COMPUTE
              • Aggregate Functions and the GROUP BY Clause
              • ▶Aggregate Functions and Datatypes
              • ▶The DISTINCT Keyword
              • ▶The GROUP BY Clause
              • ▶The COMPUTE Clause
              • Row Aggregate Functions and the COMPUTE Clause
              • ▼Rules for COMPUTE Clauses
                • More Than One Column After COMPUTE BY
                • Using More Than One COMPUTE Clause
                • Applying an Aggregate to More Than One Column
                • Using Different Aggregate Functions in the Same COMPUTE BY Clause
                • Grand Values: COMPUTE Without BY
            • ▶Using Built-in Functions
          • ▶Chapter 5 Optimizing Performance
          • ▶Chapter 6 Using Stored Procedures and Triggers
        • ▶Transact-SQL Reference
        • ▶Programming SQL Distributed Management Objects
        • ▶Guide to Microsoft Distributed Transaction Coordinator
        • ▶Programming ODBC for SQL Server
        • ▶Programming DB-Library for C
        • ▶Programming DB-Library for Visual Basic
        • ▶Programming Open Data Services
        • ▶Glossary 6.0
    • ▶Graphics and Multimedia Services
    • ▶Internet/Intranet/Extranet Services
    • ▶Networking and Distributed Services
    • ▶COM and ActiveX Object Services
    • ▶Setup and Systems Management Services
    • ▶User Interface Services
    • ▶Windows Base Services
    • ▶Reference
  • ▶SDK Documentation
  • ▶DDK Documentation
  • ▶Windows Resource Kits
  • ▶Specifications
  • ▶Knowledge Base
  • ▶Technical Articles
  • ▶Backgrounders
  • ▶Books
  • ▶Partial Books
  • ▶Periodicals
  • ▶Conference Papers