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.
  1. Prepare
  2. SQL
  3. Aggregation
  4. Revising Aggregations - The Count Function
  5. Discussions

Revising Aggregations - The Count Function

Sort by

recency

|

501 Discussions

|

  • shivanandabagi42
     + 0 comments

    select count(*) from city where population>100000;

  • keshri_ashish1
     + 0 comments
    SELECT COUNT(*)
FROM CITY
WHERE POPULATION > 100000;

  • kadalijyothi19
     + 0 comments

    SELECT COUNT(NAME) FROM ( SELECT NAME FROM CITY WHERE POPULATION > 100000 ) AS A

  • HolmesLuciano
     + 0 comments

    The COUNT() function is fundamental in SQL for aggregation, especially when analyzing datasets to determine how many rows meet certain conditions. Revising aggregations using COUNT helps reinforce understanding of how data can be grouped and summarized efficiently. Tiger Exchange 247 Login Registration

  • aliforootaninia1
     + 0 comments

    SELECT COUNT(NAME) FROM CITY WHERE POPULATION > 100000

Join us

Create a HackerRank account

Be part of a 26 million-strong community of developers

Already have an account?Log in