Header Ads Widget

Revising the select Query 1

 Revising the select Query 1:-

Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA.

The CITY table is described as follows:

CITY.jpg

 Revising the select Query 1:-

The objective of the code  Query all columns for all American cities in the CITY table with populations larger than 100000.

Mysql Code:-


select * from city where countrycode="USA" and population>100000

Recommended Post :-

HCL Coding Questions:-

Capgemini Coding Questions:-

Companies interview:-

Full C course:-    

Key points:-

Cracking the coding interview:-

 Array and string:-

Tree and graph:-

Hackerearth Problems:-

Hackerrank Problems:-

Data structure:-

 MCQs:-

Post a Comment

0 Comments