I'm new to sql.. and I have not been able to find in the books I have the answer to this question.

How do you code a select statement to pull out just the duplicate rows, based on just one field, which is not the primary key.