ora 923SQL Error: ORA-00923: FROM keyword not found where expected. Can anyone tell me where I'm going wrong with this? you don't need the WITHIN GROUP clause. it's okこのエラーはのようなにします SQL> select sysdate dual; select sysdate dual * 1でエラーがしました : ORA-00923: FROMキーワードがのに