Sort 429 Discussions, By:
Please Login in order to post a comment
Here is Oracle solution from my HackerrankPractice repository:
COUNTRYCODE = 'USA'
AND POPULATION > 100000;
Feel free to ask if you have any questions :)
Try w3 schools exercise before seeing hackerrank discussions.
https://www.w3schools.com/sql/sql_where.asp this will help you
The editor is starting from line 7. There is some code on line 4 which is causing the error. Not sure what that code is as it is not visible.
I ended the invisible statement with a ; and though the result is giving an error , it is also executing my query.
select * from CITY
where POPULATION > 100000
SELECT * FROM CITY WHERE COUNTRYCODE = "USA" AND POPULATION > 100000 ;
WHY RUNTIME ERROR ??