Ora-00933

Transact-SQL
1

I'm playing around with the Live SQL site Oracle provides, specifically the HR Schema.

Im running:

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?

2

Oracle doesn't support LIMIT, it uses OFFSET/FETCH:

Also, SQLTeam.com is a Microsoft SQL Server site, we're not experts in Oracle.