Geeks With Blogs
Michael Holland
I found something really cool with SQL yesterday that I did not think it would do; give me the distinct count of a field. For example, to calculate the number of payment terms being used for our customers in the UK I can use the following statement: SELECT COUNT(DISTINCT [Payment Terms Code]) FROM [Customer] WHERE [Country_Region Code]='GB' Posted on Wednesday, February 25, 2009 4:59 AM | Back to top

Comments on this post: SELECT COUNT DISTINCT

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © LEV | Powered by: