<div>
SELECT firstname, lastname, COUNT(*) &nbsp;FROM person &nbsp;GROUP BY firstname, lastname &nbsp;HAVING COUNT(*) &gt;&nbsp;1;
</div>


SELECT firstname, lastname, COUNT(*)  FROM person  GROUP BY firstname, lastname  HAVING COUNT(*) > 1;

<div>
Something like this perhaps:<br />
SELECT COUNT(DISTINCT firsname + lastname)<br />
FROM YourTable
</div>


Something like this perhaps:
SELECT COUNT(DISTINCT firsname + lastname)
FROM YourTable

<div>
<div class="content wysiwyg-content">
I have a table with firstName, lastName and other fields, &nbsp;I will like to count all the rows have the same firstName and lastName.
</div>
</div>


I have a table with firstName, lastName and other fields,  I will like to count all the rows have the same firstName and lastName.

SQL - How to count duplicate record

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.