Getting error ORA-00936: missing expression
ora-00936, oracle, oracle10g, sql
Solution
You should use `DISTINCT` keyword at first after the `SELECT` keyword, and remove the parenthesis, or if you need to categorize some of it, use `GROUP BY` functions. hope you're getting the desired result.
Problem
When I trying the below SQL I am getting the error ORA-00936: missing expression. Please help me on this, I want distinct on those to columns in Oracle SQL ``` SELECT rr.RPT_QUE_I, DISTINCT (rr.ed_sbmt_m, rr.RPT_RUN_STAT_C), rr.rpt_cstm_x, rr.rpt_cmplt_m, CASE WHEN rr.rpt_run_stat_c = 25453 THEN 'PENDING' WHEN rr.rpt_run_stat_c = 25454 THEN 'ACTIVE' WHEN rr.rpt_run_stat_c = 25455 THEN 'FINISHED' WHEN rr.rpt_run_stat_c = 25458 THEN 'ERROR' WHEN rr.rpt_run_stat_c = 25460 THEN 'SCHEDULED' END, cc.pro_sym_I, rr.usr_wad_ownr_i FROM audit_REPORT_RUN rr, CLIENT_COMPANY cc WHERE rr.ED_SBMT_M > TO_DATE('06/01/2012','mm/dd/yyyy') AND rr.ED_SBMT_M < TO_DATE('07/01/2012','mm/dd/yyyy') AND rr.ORG_I = cc.ORG_I ORDER BY rr.RPT_QUE_I ```