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
Sort by
recency
|
764 Discussions
|
Please Login in order to post a comment
SELECT * FROM CITY WHERE COUNTRYCODE = "USA" AND POPUALTION >100000; THIS IS MY CODE IN MY SQL CAN ANYONE HELP ME I AM STUCK FROM VERY LONG TIME
But how do we know the countrycode is USA? In the CITY table, countrycode is not given.
FOR MYSQL select *from city where population >=100000 and countrycode="USA";
SELECT * FROM CITY WHERE POPULATION > 100000 AND COUNTRYCODE = 'USA';
FOR MS SQL SERVER
select * from city where population >=100000 and countrycode='USA';