FROM keyword not found where expected when selecting * + counting

Question

So i have this table, and and in ORACLE would like to select all data + do a count.

I tried

SELECT *, count(*) as count
FROM ...

but i get the error message:

ERROR: ORA-00923: FROM keyword not found where expected ...

CONTROLNAME   BRANDNAME   GROUPTYPES    GROUPNAME 
ECU           AUDI        VERNETZER         1 
ECU           AUDI        FUSI              2 
ECU2          AUDI        FACHANWENDER  Keine zuordnung 
ECU3          AUDI        FACHANWENDER  Keine zuordnung

Thank you!

You need to qualify the table name, e.g. `SELECT yourTable.*, count(*) FROM ...` — Tim Biegeleisen, Oct 21 '16 at 08:34
Possible duplicate of [Why is selecting specified columns, and all, wrong in Oracle SQL?](http://stackoverflow.com/questions/2315295/why-is-selecting-specified-columns-and-all-wrong-in-oracle-sql) — Tim Biegeleisen, Oct 21 '16 at 08:34

score 2 · Accepted Answer · answered Oct 21 '16 at 08:34

2

SELECT table_name.*, count(*) over () as count
FROM   table_name...;

answered Oct 21 '16 at 08:34

hemalp108

1,209
1
15
23

you should add group by – CompEng Oct 21 '16 at 08:48
@ErsinGülbahar - in Oracle that is not necessary (if you aggregate over the entire table). – Mar 02 '18 at 04:12

FROM keyword not found where expected when selecting * + counting

1 Answers1