---
title: "SQL Query to Find Repeat Customer"  
description: "SQL Query to Find Repeat Customer"  
author: "Anonymous User"  
published: 2014-09-22  
updated: 2014-09-22  
canonical: https://www.mindstick.com/forum/2266/sql-query-to-find-repeat-customer  
category: "database"  
tags: ["database"]  
reading_time: 1 minute  

---

# SQL Query to Find Repeat Customer

In an [[orders](https://answers.mindstick.com/qa/43206/what-were-the-fundamental-orders-of-connecticut-and-who-wrote-them)] [table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap), some rows have the same [value](https://www.mindstick.com/articles/23219/an-optimized-description-adds-value-to-experience-and-in-turn-effectively-guest-posting-packages) for the **[Customer](https://www.mindstick.com/articles/325839/how-to-improve-your-business-level-of-customer-service)** [column](https://www.mindstick.com/forum/33860/how-to-calculate-column-summary-in-sql-server) meaning they are [repeat](https://www.mindstick.com/forum/156775/give-an-example-of-the-linq-repeat-method) 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](https://www.mindstick.com/articles/330/triggers-in-sql-server) [product](https://www.mindstick.com/articles/75385/full-product-keys) id different? I get the all customer which are repeated on the basis of customer Name.

## Replies

### Reply by Anchal Kesharwani

hi jeet,\
You should try to this:

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


---

Original Source: https://www.mindstick.com/forum/2266/sql-query-to-find-repeat-customer

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.