SQL Query to Find Repeat Customer

Anonymous User 3800 22 Sep 2014

In an [orders] table, some rows have the same value for the Customer column meaning they are repeat customers.

ProductID Customer

111 Mr. John

333 Mr. Rakesh

444 Mr. John

777 Mr. Shiva

999 Mr. Rakesh

What can I do to find the repeat customer instead of product id different? I get the all customer which are repeated on the basis of customer Name.

Ask by Anonymous User

Updated 22 Sep 2014

Anchal Kesharwani 22 Sep 2014

hi jeet,

You should try to this:

SELECT Customer FROM yourTable 
GROUP BY Customer
HAVING COUNT(*) > 1

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

forum