You are viewing a single comment's thread. Return to all comments →
[ORACLE] Use exists and not exists for the faster execution:
select name from city c where exists (select 1 from country where code=c.countrycode and continent='Africa');
Seems like cookies are disabled on this browser, please enable them to open this website
African Cities
You are viewing a single comment's thread. Return to all comments →
[ORACLE] Use exists and not exists for the faster execution:
select name from city c where exists (select 1 from country where code=c.countrycode and continent='Africa');