query

hi,

how to know if the same users appears more than once in the database?Hi there,

I will suggest to you to please look through this site to learn about the basic SQL.

SQL

HTH|||Try this:
SELECT * FROM usersTable
WHERE userId In (SELECT userId FROM usersTable
GROUP BY userId HAVING Count(*) >1) ORDER BY userId;

Regards
Fredr!ksql