Simon wrote:Here's one way to get all duplicates from the "name" column:> Hi,
> I am looking for double entry in my database.
> So that, for example, if the name bob was listed more than once I would get
> the name and the number of times it is listed.
> What select statement should I use to list all the similar entries?
name, count(*) as how_many
how_many > 1
_ _ _ _
(_|| | |(_|>< The Data Charmer