Top "Ora-00979" questions

ORA-00979: not a GROUP BY expression

ORA-00979 not a group by expression

I am getting ORA-00979 with the following query: SELECT cr.review_sk, cr.cs_sk, cr.full_name, tolist(to_…

Read More
sql oracle ora-00979
GROUP BY with MAX(DATE)

I'm trying to list the latest destination (MAX departure time) for each train in a table, for example: Train Dest …

Read More
sql oracle group-by greatest-n-per-group ora-00979
SQL GROUP BY - Using COUNT() function

I've been doing a task which involves creating a database for a hospital and I've been encountering a very frustrating …

Read More
sql oracle group-by ora-00979
ORA-00979: not a GROUP BY expression issue

I am performing the following request and I get a "ORA-00979: not a GROUP BY expression" error. select distinct field1, …

Read More
sql oracle oracle11g ora-00979
Query works with Oracle 10g but not with 11g?

DECLARE trn VARCHAR2(2) := 'DD'; cur SYS_REFCURSOR; BEGIN OPEN cur FOR SELECT TRUNC(some_date, trn), NULL AS dummy_2, COUNT( …

Read More
sql oracle plsql oracle11g ora-00979
Find the highest number of occurences in a column in SQL

Given this table: Order custName description to_char(price) A desa $14 B desb $14 C desc $21 D desd $65 E dese $21 F …

Read More
sql oracle ora-00979
SQL Group By function(column) - Now can't Select that column

I used the HR employee schema in Oracle Express and I wanted to select employees that were hired on a …

Read More
sql oracle aggregate-functions ora-00979