Count function behavior.

vishalneeraj-24503
Posted by vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 227
SELECT COUNT(ALL ADDRESS) FROM TEST1; --ROWS EXCEPT NULL VALUES 
SELECT COUNT(DISTINCT ADDRESS) FROM TEST1; --ELEMINATE DUPLICATE ROWS
SELECT COUNT(ADDRESS) FROM TEST1; --ROWS EXCEPT NULL VALUES
SELECT COUNT(*) FROM TEST1; -- ALL ROWS INCLUDE NULL VALUES

Comments or Responses

Login to post response