ORA-00979 not a group by expression

You must put all columns of the SELECT in the GROUP BY or use functions on them which compress the results to a single value (like MIN, MAX or SUM).

A simple example to understand why this happens: Imagine you have a database like this:

FOO BAR
0   A
0   B

and you run SELECT * FROM table GROUP BY foo. This means the database must return a single row as result with the first column 0 to fulfill the GROUP BY but there are now two values of bar to chose from. Which result would you expect – A or B? Or should the database return more than one row, violating the contract of GROUP BY?

Related Posts:

  1. ORA-00904: invalid identifier
  2. how to fix oracle ORA-01722 invalid number error
  3. ORA-00907: missing right parenthesis
  4. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  5. ORA-01843 not a valid month- Comparing Dates
  6. ORA-00918: column ambiguously defined in SELECT *
  7. Oracle error : ORA-00905: Missing keyword
  8. How do I limit the number of rows returned by an Oracle query after ordering?
  9. Oracle SELECT TOP 10 records
  10. Can a foreign key be NULL and/or duplicate?
  11. How to Select Top 100 rows in Oracle?
  12. ORA-12560: TNS:protocol adaptor error
  13. ORA-00972 identifier is too long alias column name
  14. Oracle Apex column link from LOV values
  15. PLS-00103: Encountered the symbol when expecting one of the following:
  16. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  17. ORA-00918: column ambiguously defined in SELECT *
  18. ORA-00918: column ambiguously defined in SELECT *
  19. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  20. ORA-01861: literal does not match format string
  21. What is it exactly a BLOB in a DBMS context
  22. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  23. How do you create a temporary table in an Oracle database?
  24. Oracle “Partition By” Keyword
  25. How to insert date values into table
  26. Oracle SQL: Update a table with data from another table
  27. SQL selecting rows by most recent date with two unique columns
  28. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  29. Comparing Dates in Oracle SQL
  30. Convert timestamp to date in Oracle SQL
  31. How do I reset a sequence in Oracle?
  32. Update statement with inner join on Oracle
  33. MySQL equivalent of DECODE function in Oracle
  34. Oracle: If Table Exists
  35. DATEDIFF function in Oracle
  36. How to create id with AUTO_INCREMENT on Oracle?
  37. LEFT function in Oracle
  38. What is the difference between Views and Materialized Views in Oracle?
  39. How do I view the Explain Plan in Oracle Sql developer?
  40. ORA-01779: cannot modify a column which maps to a non key-preserved table
  41. ORA-01735: invalid ALTER TABLE option – Toad
  42. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  43. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  44. SQL WITH clause example [duplicate]
  45. The wait operation timed out. ASP
  46. SQL query to select dates between two dates
  47. MySQL – Operand should contain 1 column(s)
  48. SQL SELECT WHERE field contains words
  49. Must declare the scalar variable
  50. How can I do a FULL OUTER JOIN in MySQL?
  51. How do I escape a single quote in SQL Server?
  52. T-SQL split string based on delimiter
  53. Finding duplicate values in a SQL table
  54. MySQL Cannot Add Foreign Key Constraint
  55. How do I import an SQL file using the command line in MySQL?
  56. SQL not a single-group group function
  57. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  58. Difference between JOIN and INNER JOIN
  59. SQL error “ORA-01722: invalid number”
  60. What is the difference between JOIN and UNION?
  61. MySQL Multiple Joins in one query?
  62. “CASE” statement within “WHERE” clause in SQL Server 2008
  63. What does the following Oracle error mean: invalid column index
  64. What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?
  65. Combining “LIKE” and “IN” for SQL Server
  66. SQL Server WITH statement
  67. How to SUM two fields within an SQL query
  68. DateTime2 vs DateTime in SQL Server
  69. Algebra Relational sql GROUP BY SORT BY ORDER BY
  70. What is the equivalent of ‘describe table’ in SQL Server?
  71. Add a column with a default value to an existing table in SQL Server
  72. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  73. Using group by on multiple columns
  74. What is the purpose of using WHERE 1=1 in SQL statements?
  75. How do you force mysql LIKE to be case sensitive?
  76. What is the difference between a stored procedure and a view?
  77. Bulk load data conversion error (truncation)
  78. How to order by with union in SQL?
  79. PostgreSQL create table if not exists
  80. Incorrect syntax near ”
  81. MySQL: Can’t create table (errno: 150)
  82. GROUP BY and COUNT using ActiveRecord
  83. MySQL – Get row number on select
  84. What does * mean in sql?
  85. How to truncate the text returned for a column in a MySQL query
  86. PLS-00049 bad bind variable While using :OLD
  87. How To Write An Inner Join With WP Query
  88. Update user_login, user_nicename, and display_name
  89. Change sticky status of posts from phpMyAdmin
  90. How to import a Typo3 database to a wordpress site?
  91. Clean up very big and very dirty database
  92. How can I convert everything from category X to have post format Link
  93. Bulk delete WordPress Post and all metadata, etc using SQL query
  94. Reset post IDs with all post meta
  95. How to Add or Change Post Title
  96. Why does DROP TABLE-ing the `wp_options` reset my user session?
  97. How to refactor DB queries for better TTFB in WordPress?
  98. query sql-table and change entities
  99. Backtick (MySQL norm) added to SQL Server Query causing error
  100. Firebase with WordPress instead of SQL?

Leave a Comment