Thursday, March 10, 2011

Difference Between COUNT(DISTINCT) vs COUNT(ALL)

SELECT COUNT([FieldName])
FROM [TableName]
GOSELECT COUNT(ALL [FieldName])
FROM [TableName]
GOSELECT COUNT(DISTINCT [FieldName])
FROM [TableName]
GO
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)