Sams Teach Yourself SQL in 24 Hours | GROUP BY Versus ORDER BY | InformIT
Note The GROUP BY clause can be used in the CREATE VIEW statement to sort data, but the ORDER BY clause is not allowed in the CREATE VIEW statement. The CREATE VIEW statement is discussed in depth in Hour 20, "Creating and Using Views and ......