I'm playing around with the Live SQL site Oracle provides, specifically the HR Schema.
SELECT job_id, COUNT(*) AS frequency FROM hr.job_history GROUP BY job_id ORDER BY frequency DESC LIMIT 2;
I keep getting ORA-00933: SQL command not properly ended. Ive tried with and without the " ; " no change. Any ideas?