Re: How to filter find duplicate and show row with same field?

[Phillip Ward]

Sounds a mite like a Homework assignment to me so I won't jump straight to an answer.

You'll need to use the "group by" and "having" clauses of the select statement to find the rows where each name appears more than once.

Having found that set of rows, you'll need to use the name to go back to the original table and pull all of the data you want.

Regards, Phill W.