Collections:
Group Functions with Non-group Selections in MySQL
Can Group Functions Be Mixed with Non-group Selection Fields in MySQL?
✍: FYIcenter.com
If a group function is used in the SELECT clause, all other selection fields must be group level fields. Non-group fields can not be mixed with group fields in the SELECT clause. The script below gives you an example of invalid SELECT statements with group and non-group selection fields:
mysql> SELECT COUNT(*), url FROM fyi_links; ERROR 1140 (42000): Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
In this example, COUNT(*) is a group field and "url" is a non-group field.
⇒ Dividing Query Output into Groups in MySQL
⇐ Using Group Functions in the SELECT Clause in MySQL
2017-10-16, 1448🔥, 0💬
Popular Posts:
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...