From Keyword Not Found Where Expected (Oracle SQL)

SUM(part_gold) as "Number of Gold Medals"

 create table items(dates varchar2(200), item VARCHAR2(200));

 insert into items values ('01-01-20', 'apple');

 insert into items values ('01-01-20', 'apple');

 insert into items values ('01-01-20', 'pear');

 insert into items values ('01-01-20', 'pear');

 insert into items values ('01-02-20', 'pear');

 insert into items values ('01-02-20', 'pear');

 insert into items values ('01-02-20', 'pear');

 insert into items values ('01-02-20', 'orange');

select dates, item
     from 
     (
     SELECT dates,item, rank() OVER (PARTITION by dates ORDER BY item_count DESC) AS date_rank
     FROM 
     (
     SELECT dates, item, count(*) AS item_count
     FROM items
     GROUP BY dates, item
     ORDER BY dates) ) 
     where date_rank=1;

DATES	ITEM
01-01-20	apple
01-01-20	pear
01-02-20	pear

Leetcode Oracle - ORA-00923: FROM keyword not found where expected

If you need to select only all the columns then * without the alias is fine. But if You need to give alias of the table wherever you want to select all the columns of the table using * and also another expression in SELECT clause.

with TEMP AS 
( SELECT
    COL1,
    COL2
FROM table )
, TEMP1 AS 
(SELECT
    T.*, -- alias here
    "hello"   AS COL3
FROM TEMP T
)
select * FROM TEMP1;

with temp as
(
    select d.Name as Department,
    e.Name as Employee,
    e.Salary as Salary
    from employee e
    join department d
    on e.DepartmentId = d.Id
)
select T.* -- alias here
, rank() over (partition by department order by salary desc) as rr
from temp T;

Oracle SQL Developer - Error: FROM keyword not found where expected

You have a trailing comma in the last table (proddta.f4301 c) of FROM clause and should become

... 
FROM PRODDTA.F5543170 a,
     proddta.f4209 b,
     proddta.f4301 c  
...

which should be removed.

You also have a trailing comma in your select statement that should also be removed.

...
rank() over (partition by pckcoo, pcdoco, pcdcto, pclnid order by FX_PARA_GREGORIANA(HORDJ, 'DD/MM/YYYY')||' '||rpad(HORDT,6,'0') desc) as rank
...

Finally, for table alias you need to use double instead of single quotes:

select  
   PCKCOO AS "COMPANHIA_DO_PEDIDO_NUMERO_DO_PEDIDO",
   PCDOCO AS "DOCUMENTO_NUMERO_DA_OS_FATURA",
   PCDCTO AS "TIPO_DE_ORDEM",
   PCSFXO AS "SUFIXO_DO_PEDIDO",
   rpad(HORDT,'0',6) AS "HORARIO_DE_LIBERACAO",
...

---

Related Topics