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