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.
Loading...
  1. Practice
  2. SQL
  3. Basic Select
  4. Revising the Select Query I
  5. Discussions

Revising the Select Query I

Sort 161 Discussions, By:

votes

  • marinskiy + 2 comments

    Here is Oracle solution from my HackerrankPractice repository:

    SELECT *
FROM CITY
WHERE
    COUNTRYCODE = 'USA'
    AND POPULATION > 100000;

    Feel free to ask if you have any questions :)

    • mohitvarshneygl1 + 4 comments

      select * from city where population >10000 AND countrycode='USA';

      see above query i have tried lots of time but i am not able to solve so plz help me

      • marinskiy + 0 comments

        You have a typo: population >10000 instead of population >100000

      • yogesh_bavishi + 0 comments

        i had the same problem..... change the order of conditions.. your code will be run successfully.. thank

      • vicentetao + 0 comments

        maybe CITY?

      • bowangjava + 0 comments

        I had the same issue, but surprisingly after I changed select into SELECT, from into FROM, etc. the query passed.

    • ajayyadav95sab + 0 comments

      what the problem in this

  • lpg2004 + 0 comments

    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 and COUNTRYCODE='USA' ;

  • rayedox + 0 comments

    Solution of the given problem in Microsoft Sql Server by Rayedox Technologies :

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

    Please visit www.rayedox.com for futher queries or mail us at support@rayedox.com or rayedox@gmail.com

  • aayushsingla720 + 0 comments

    IF I write alll the sql term write in lower case then it is run or not

  • brandon_dicicco + 0 comments

    MS SQL Server

    SELECT * FROM CITY
WHERE COUNTRYCODE = "USA" 
AND POPULATION > 100000;

  • mdihr15 + 1 comment

    SELECT * FROM CITY WHERE COUNTRYCODE="USA" This is my query.But it give wrong answer.What's wrong

    • Zedanlou + 0 comments

      You're forgetting population. And in my experience, USA worked better in single quotes ' rather than double quotes ".

  • doting_div + 1 comment

    This worked too!

    SELECT *

    FROM City

    HAVING Population > 100000 and Countrycode = 'USA';

    • fevieira + 0 comments

      since you don't have an aggregation, you actually don't need to use having

  • tom_pum_tfg + 0 comments

    A mi me funciono en el servidor ms sql select * from city where countrycode='USA' AND population > 100000;

  • kannu_12priya + 0 comments

    SELECT * FROM CITY WHERE COUNTRYCODE = 'USA' AND POPULATION > 100000;

  • souravkkt0404191 + 0 comments

    select * from city where COUNTRYCODE = 'USA' AND POPULATION > 100000;

Load more conversations