Skip to content

Learn2Done

    • HOME
    • HTML
    • CSS
    • C
    • C++
    • C#
    • JAVA
    • SQL
    • AWS
    • INTERVIEW QUESTIONS
      • Current Page Parent SQL INTERVIEW QUESTONS
    • PROGRAMS
      • C PROGRAMS
      • C++ PROGRAMS
      • JAVA PROGRAMS
    • Data Science
    • Business Management
    • DevOps
    • Docker
    • Git

    RANK() vs DENSE_RANK vs ROW_NUMBER

    The function of count(*), count(1), count(‘a’) is same.

    That means that they all gives count of all the rows including null values.

    But the function count(column_name) is different.

    As when we specify a particular column in count parameter, then it gives the count of the rows excluding null values.

    September 7, 2022 by Learn2Done SQL INTERVIEW QUESTONS
    • Next C++ ENCAPSULATION
    • Previous Drop table vs Truncate vs Delete

    Recent Posts

    • Git Reset to Specific Commit
    • Git Revert Commit & Local
    • Git Revert Commit
    • Git Remove Remote Repo
    • Git List Remote Repo
    • Git Reset to Specific Commit

    • Git Revert Commit & Local

    • Git Revert Commit

    • Git Remove Remote Repo

    Learn2Done © 2023 with ❤ by AlexTech Software Solutions