September 24, 2004

sql to count distinct records

In MS SQL Server 2000, executel this statement,
select count(distinct customer_ename) from customer
Never imagine it could be so intuitive:)

No comments: