Find the capital and the name where the capital includes the name of the country

Answer:

 

SELECT name,capital  ROM world WHERE capital LIKE concat(concat(‘%’,name),’%’)

CheapSexCams
You can leave a response, or trackback from your own site.

Leave a Reply

Powered by k2schools
%d bloggers like this: