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.
  • HackerRank Home

    HackerRank

  • |
  • Prepare
  • Certify
  • Compete
  • Hiring developers?
  1. Prepare
  2. SQL
  3. Basic Select
  4. Revising the Select Query I
  5. Discussions

Revising the Select Query I

Problem
Submissions
Leaderboard
Discussions
Editorial

Sort 571 Discussions, By:

recency

Please Login in order to post a comment

  • gtj9966
    2 days ago+ 0 comments
    SELECT  *
    FROM CITY
    WHERE (POPULATION > 100000) AND (COUNTRYCODE = 'USA')
    
    0|
    Permalink
  • cahitbarkinozer
    2 days ago+ 0 comments

    Oracle

    SELECT *
    FROM CITY
    WHERE CountryCode ='USA'
    AND Population>100000;
    
    0|
    Permalink
  • coder_mahesh
    4 days ago+ 0 comments
    select * from city where population>100000 and countrycode='USA';
    
    0|
    Permalink
  • roshankumar350
    6 days ago+ 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|
    Permalink
  • esmaellucaya
    1 week ago+ 0 comments

    MySQL:

    Select * From CITY Where POPULATION > 10000 And COUNTRYCODE = "USA";

    0|
    Permalink
Load more conversations

Need Help?


View editorial
View top submissions
  • Blog
  • Scoring
  • Environment
  • FAQ
  • About Us
  • Support
  • Careers
  • Terms Of Service
  • Privacy Policy