The GROUP BY clause of the SQL SELECT statement (for ORACLE, MySQL, SQL Server, etc.)

Описание: The Structured Query Language (SQL) is the most powerful database language in use today. SELECT is the most powerful statement within SQL, and the GROUP BY clause is part of the reason. Learn the inner workings of GROUP BY and make yourself a more powerful database professional! From Steve O'Hearn of databasetraining.com and Corbinian, author of Oracle Press books, including the first "expert" level certification exam guide from Oracle Corporation, the "OCA Oracle Database SQL Expert Exam Guide: Exam 1Z0-047". (http://www.amazon.com/Oracle-Database...)

This information is good for use with Oracle, MySQL, Microsoft SQL Server, and any ANSI-standard SQL database.

Full transcript available here: http://databasetraining.com/node/3