Query help

[micjohnson]

How to I write query to get duplicate column count.

For eg,

One user has 5 accounts on a website with 5 different user logins(primary key), same email address and same password on 5 account.

How do I find that how many users has more than one accounts with same email and same password?

Thanks in advance.

 

[bborissov]

SELECT eMail, [Password]
FROM YourTable
GROUP BY eMail, [Password]
HAVING COUNT(*) > 1

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.