<div>
You can use below mentioned query...<br />
<br />

<pre><code id="code-20-40738403-1">select reference,serialno
from table1
Having count(serialno)&gt;1</code></pre>
<br />
Saurabh...
</div>


You can use below mentioned query...



select reference,serialno
from table1
Having count(serialno)>1


Saurabh...

<div>
Saurabh your query is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
</div>


Saurabh your query is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

<div>
<div class="content wysiwyg-content">
Hi, Below is my test data and I need to get only those references with duplicate serial nos. So<br />
for my below data, I only need to get the below result. can anyone please give me that tsql code ?<br />
<br />
abcd &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;14157464<br />
abcd &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;14157454<br />
<br />
<br />
<br />
<br />
reference &nbsp; &nbsp; &nbsp;serialno<br />
<br />
abcd &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;14157456<br />
abcd &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;14157464<br />
abcd &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;14157454<br />
xyz &nbsp; &nbsp; &nbsp;13542546<br />
<br />
Thanks
</div>
</div>


Hi, Below is my test data and I need to get only those references with duplicate serial nos. So
for my below data, I only need to get the below result. can anyone please give me that tsql code ?

abcd	 14157464
abcd	 14157454




reference      serialno

abcd	 14157456
abcd	 14157464
abcd	 14157454
xyz      13542546

Thanks

selecting duplicate data

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.