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. Aggregation
  4. Revising Aggregations - The Count Function
  5. Discussions

Revising Aggregations - The Count Function

Sort 31 Discussions, By:

votes

  • marinskiy + 0 comments

    Here is Oracle solution from my HackerrankPractice repository:

    SELECT COUNT(*)
FROM City
WHERE Population > 100000;

    Feel free to ask if you have any questions :)

  • pedrokarneiro + 2 comments
    /* This solution works for any of the listed RDBMS:
DB2, mySQL, Oracle, SQL Server
*/

SELECT COUNT(id)
FROM city
WHERE population > 100000;
    • SM
      ShivMohanKaushik + 1 comment

      wrong mr

      • pedrokarneiro + 0 comments

        so, let us re-run it and check...

    • pedrokarneiro + 0 comments

      Just tested it again and it passed the test cases for all listed RDBMSs.

  • DC
    danielgcwik + 2 comments

    select count(name) from city where population > 100000; this works in oracle

    • DC
      danielgcwik + 0 comments

      you cal also use * or id in count()

    • SM
      ShivMohanKaushik + 0 comments

      wrong in mysql

  • bhuyan_reshma90 + 0 comments

    SELECT COUNT(*) FROM CITY WHERE POPULATION > 100000

  • hwang20 + 0 comments

    SELECT COUNT(DISTINCT NAME) FROM CITY WHERE POPULATION > 100000

  • utsavsakshi1999 + 0 comments

    SELECT COUNT(ID) FROM CITY WHERE POPULATION>100000; MySQL solution

  • SA
    sindhuarju + 0 comments

    select sum(count(countrycode)) from city where population > 100000 group by countrycode;

  • vijay13_sdbce + 0 comments
    select count(name) from city where population > 100000;

  • RM
    rahulmu4our + 0 comments

    For MySQLthis have worked for me

    SELECT COUNT(NAME)
  FROM CITY
  WHERE POPULATION > 100000;

  • AA
    anjanat027 + 0 comments

    select count(name) from city where population >100000

Load more conversations