counting the no. of records through query

[santhosh kumar]

Hi,
My problem is. Counting the number of records from table. When we counting the records we need to count one for same duplicate records.
Example:
Table :Emp
EmpNo:
100
101
101
101
102
102
103
104

When we count the above records count should be 5. Why because 100 are 1, 101 are 3, here instead of three records we have to take count as 1,because 101 has duplicates. 102s are 2 , here instead of two rcords we have to take count as 1,because 102 has duplicates. 103 is 1, 104 is 1. Now if we count the total will be 5. This is the way i need to count the records.

Please help me on this, hw to write the query...
I will look for your reply..

[DikDude]

Look into using DISTINCT.

[alanpaul_t]

hi,

this will do :

SELECT COUNT(distinct EmpNo) FROM Emp