A sql interface won't let me put semicolons in my SQL queries. What do I do to circumvent this?
select country.country, count(customer.customer_id) as country_count
from customer
join address on customer.address_id = address.address_id
join city on address.city_id = city.city_id
join country on city.country_id = country.country_id
group by country.country_id
order by country_count desc;
limit 10
If I kill the semicolon the interface gives:
Error: ORA-00907: missing right parenthesis.
If I put in the semicolon the interface gives:
Error: ORA-00911: invalid character
In my sqllite program the query works just fine without the ;
.