<div>
You did not present any table structure or sample query, so this is maybe not what you need:
<pre><code class="code-1 nolinks" id="code-20-43069546-1"><span>SELECT FirstName, LastName, COUNT(*)</span>
<span>  FROM YourTable</span>
<span> GROUP BY FirstName, LastName</span>
<span> HAVING COUNT(*) &gt; 1</span>
</code></pre>
</div>


<div>
And if you would like to display whole rows containing above names use the following query:
<pre><code class="code-1 nolinks" id="code-20-43069547-1"><span>SELECT Y.* </span>
<span>  FROM YourTable Y</span>
<span>  JOIN (SELECT FirstName, LastName, COUNT(*) cnt</span>
<span>          FROM YourTable</span>
<span>           GROUP BY FirstName, LastName</span>
<span>          HAVING COUNT(*) &gt; 1) D </span>
<span>    ON D.FirstName = Y.FirstName AND D.LastName = Y.LastName</span>
<span> ORDER BY Y.FirstName, Y.LastName</span>
</code></pre>
</div>


<div>
pcelba - thanks, but that gives me a count. I don't want a count if there are multiple records. I don't care about multiple records, but rather records that have two identical fields (firstname and lastname).<br />
<br />
In other words, I want to show the records - and only those records - that have the FirstName identical to the LastName.
</div>


N2012

<div>
That's what I thought I tried before and got an error.<br />
Works. &nbsp;:)
</div>


<div>
<div class="content wysiwyg-content">
I can't seem to be able to create/find a query that shows results (all records) that have the same First and Last Name (two separate fields).
</div>
</div>


I can't seem to be able to create/find a query that shows results (all records) that have the same First and Last Name (two separate fields).

SQL Query of records with two equal columns

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.