[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 343
  • Last Modified:

FIND DUPLICATE RECORDS

Hi all is any query for find duplicate record in all the fields of the rows?

thank you a lot
0
Ernesto
Asked:
Ernesto
1 Solution
 
Ephraim WangoyaCommented:

select Field1, Field2, Field3, .....
from Table1
group by Field1, Field2, Field3, .....
having count(*) > 1
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now