Difference between COUNT (1), COUNT (*) and COUNT(COLUMN_NAME)
COUNT () is a function in SQL Server counts the number of rows. This method accepts only on parameter. Though it is a simple function, it creates a bit confusion based on the parameters (*, 1 and COLUM_NAME). You might have seen the COUNT () function has been used in the below formats COUNT (1) […]
read more »