Friday, 11 July 2014

Using COUNT function properly



I have a table with a single column ID with the below values.Here the '-' indicates Null value.
What would be the output of :





SELECT COUNT(*),COUNT(ID),COUNT(1) FROM ID;


No comments:

Post a Comment