We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Revising the Select Query I
Revising the Select Query I
+ 0 comments SELECT * FROM CITY WHERE (POPULATION > 100000) AND (COUNTRYCODE = 'USA')
+ 0 comments Oracle
SELECT * FROM CITY WHERE CountryCode ='USA' AND Population>100000;
+ 0 comments select * from city where population>100000 and countrycode='USA';
+ 0 comments MYSQL SOLUTION
SELECT ID, NAME, COUNTRYCODE, DISTRICT, POPULATION FROM CITY WHERE POPULATION > 100000 AND COUNTRYCODE = 'USA'
SELECT * FROM CITY WHERE POPULATION > 100000 AND COUNTRYCODE = 'USA'
+ 0 comments MySQL:
Select * From CITY Where POPULATION > 10000 And COUNTRYCODE = "USA";
Load more conversations
Sort 571 Discussions, By:
Please Login in order to post a comment