<div>
select SSN from yourtable group by SSN having count(*) &gt;&nbsp;1
</div>


<div>
<div class="content wysiwyg-content">
I have a table . I need only see the SSN whichare duplicate
</div>
</div>


I have a table . I need only see the SSN whichare duplicate

Coldfusion and SQL

Web development software is used to create websites for both the Internet and intranets. Software can be either locally installed or operated through a cloud interface, and ranges in complexity from simple text editors to full-fledged integrated development environments (IDEs) that include graphics, video, audio, scripting and database support.

Web Development Software

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.