Select count(column_a),column_a
from table
group by column_a
having count(column_a) > 1;
NB: This will identify duplicate entries in a specific column in
your database table(In this case Column_A).
It will give you the value in the column, adn how many entries there
are for
that value.
Piero Stanchi wrote:
Hello.
I want to print all the entries in a table that are present more than
one time. What kind of select statement must I do?
Thank you for any help.
Piero
Received on Wed May 26 1999 - 05:50:18 CDT
