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 II
  5. Discussions

Revising the Select Query II

Problem
Submissions
Leaderboard
Discussions
Editorial

Sort 446 Discussions, By:

recency

Please Login in order to post a comment

  • modemharikumar
    2 weeks ago+ 0 comments

    Microsoft SQL Server Code

    SELECT NAME FROM CITY WHERE COUNTRYCODE = 'USA' AND POPULATION > 120000;
    
    0|
    Permalink
  • smfaraanali02
    2 weeks ago+ 2 comments

    Can anyone tell why can we not use having here

    0|
    Permalink
  • roshankumar350
    2 weeks ago+ 0 comments

    MYSQL SOLUTION

    SELECT NAME FROM CITY WHERE COUNTRYCODE = 'USA' && POPULATION > 120000
    
    0|
    Permalink
  • ni_sh_ant____
    2 weeks ago+ 0 comments

    select name from city where population>120000 and countrycode="usa"

    0|
    Permalink
  • andriashkujur
    2 weeks ago+ 0 comments

    Got it in the first try with

    select name from city where population > 120000 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