Query works in MySQL not Oracle
The following SQL statement works in MySQL but not with Oracle: SELECT *, MAX(COLUMN_A) FROM table_xyz WHERE COLUMN_A <= 100 GROUP BY COLUMN_A Oracle complaint: "FROM keyword not found where expected" ...
ora-00923
Can you create a case statement in select command that evaluates two different table fields?
SELECT HQRH_BADGENO, HQRH_SHIFT, HQBD_BADGENAME, HQRH_DISCRRECONCILE, HQRH_ADJUSTAMOUNT, HQRH_DISCRADJUSTMENT, CASE HQRH_DISCRRECONCILE WHEN 'HQRH_DISCRRECONCILE <0' THEN 'HQRH_ADJUSTAMOUNT' WHEN 'HQRH_ADJUSTAMOUNT>0' THEN 'HQRH_ADJUSTAMOUNT' WHEN 'H...