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 36 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;
    • 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.

  • danielgcwik + 2 comments

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

    • danielgcwik + 0 comments

      you cal also use * or id in count()

    • ShivMohanKaushik + 0 comments

      wrong in mysql

  • pralabhsaxena05 + 0 comments

    SELECT count(district) FROM city WHERE population>100000 ;

  • nizamcse_seu + 0 comments
    SELECT COUNT(NAME) FROM CITY
WHERE POPULATION>100000;

  • tranlq91 + 0 comments

    Hi i've tried another solution but i don't know why it's wrong:

    SELECT COUNT(CASE WHEN Population > 100000 THEN 1 ELSE 0 END) AS result FROM City;

  • thaihoc081098 + 0 comments

    select count(*) from CITY where Population > 100000

  • tsvetoslav_tsve1 + 0 comments

    ORACLE

    SELECT count(id)
FROM city
WHERE population > 100000;

  • bhuyan_reshma90 + 0 comments

    SELECT COUNT(*) FROM CITY WHERE POPULATION > 100000

  • hwang20 + 0 comments

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

Load more conversations