Posts Tagged ‘sql query’

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),’%’)

Powered by k2schools