StackOverflow Questions for Tag: ora-00979

Theresa

Reputation: 3645

ORA-00979 not a group by expression

sqloracle-databaseora-00979

Score: 200

Answers: 10

cactus8888

Reputation: 16

sql oracle query group by issue

sqloracle-databasegroup-byora-00979

Score: 0

Answers: 0

CodingStudent

Reputation: 65

Getting ORA-00979 not a group by expression /ERROR

sqloracle-databaseora-00979

Score: 0

Answers: 2

Stefan K

Reputation: 57

Resolve ORA-00979: not a group by expression

sqloracle-databaseora-00979

Score: 0

Answers: 1

Morri

Reputation: 581

Oracle, ORDER BY with view results in error

oracle-databaseviewsql-order-byora-00979

Score: 0

Answers: 1

lulu3131

Reputation: 25

ORA-00979 : select distinct(concat column) not a group by expression

sqloracle-databaseora-00979

Score: 1

Answers: 1

user2102665

Reputation: 505

GROUP BY with flagged value

sqloracle-databaseora-00979

Score: 1

Answers: 2

Rizal Maulana

Reputation: 89

i got error ORA-00979: not a GROUP BY expression

sqloracle-databaseora-00979

Score: 0

Answers: 1

beginner

Reputation: 3

Getting "ORA-00979: not a GROUP BY expression" in a PHP app

phpsqloracle-databaseora-00979

Score: 0

Answers: 1

David Fletcher

Reputation: 305

Oracle COUNT(DISTINCT expr) causes ORA-00979 error

oracle-databaseora-00979

Score: 1

Answers: 1

Manoj

Reputation: 3

Select query succeeds however Insert using same query fails with ORA-00979 (not a GROUP BY expression)

oracle-databasegroup-byora-00979

Score: 0

Answers: 0

SKINNY

Reputation: 3

ORA-00979 ORA-22818

oracle-databaseora-00979

Score: -1

Answers: 2

Aries

Reputation: 2281

GROUP BY with MAX(DATE)

sqloracle-databasegroup-bygreatest-n-per-groupora-00979

Score: 221

Answers: 6

dsz36

Reputation: 127

ORA-00979: not a GROUP BY expression with a simple example

sqloracle-databaseoracle11ggroup-byora-00979

Score: 6

Answers: 3

Nawaf

Reputation: 540

Using aggregate function to return minimum value

sqloracle-databasegroup-byora-00979

Score: 0

Answers: 4

zoro

Reputation: 17

sql issue with having clause

sqloracle-databasegroup-byhavingora-00979

Score: 0

Answers: 3

user2992757

Reputation: 65

ora-00979 not a GROUP BY expression help spool

sqloracle-databasegroup-byora-00979

Score: 1

Answers: 1

NewGuy

Reputation: 3413

ORA-00979, but I have elements in my SELECT in my GROUP BY statement

sqloracle-databaseora-00979

Score: 1

Answers: 2

sriramdev

Reputation: 779

ORA-00979 not a Group By function error

oracle-databaseora-00979

Score: 0

Answers: 3

user4190387

Reputation:

SQL Group By error ORA-00979

sqloracle10gora-00979

Score: 0

Answers: 2

PreviousPage 1Next

StackOverflow Questions for Tag: ora-00979

ORA-00979 not a group by expression

sql oracle query group by issue

Getting ORA-00979 not a group by expression /ERROR

Resolve ORA-00979: not a group by expression

Oracle, ORDER BY with view results in error

ORA-00979 : select distinct(concat column) not a group by expression

GROUP BY with flagged value

i got error ORA-00979: not a GROUP BY expression

Getting &quot;ORA-00979: not a GROUP BY expression&quot; in a PHP app

Oracle COUNT(DISTINCT expr) causes ORA-00979 error

Select query succeeds however Insert using same query fails with ORA-00979 (not a GROUP BY expression)

ORA-00979 ORA-22818

GROUP BY with MAX(DATE)

ORA-00979: not a GROUP BY expression with a simple example

Using aggregate function to return minimum value

sql issue with having clause

ora-00979 not a GROUP BY expression help spool

ORA-00979, but I have elements in my SELECT in my GROUP BY statement

ORA-00979 not a Group By function error

SQL Group By error ORA-00979

Getting "ORA-00979: not a GROUP BY expression" in a PHP app