SQL Query of records with two equal columns

You did not present any table structure or sample query, so this is maybe not what you need:

SELECT FirstName, LastName, COUNT(*)
  FROM YourTable
 GROUP BY FirstName, LastName
 HAVING COUNT(*) > 1

Select allOpen in new window

And if you would like to display whole rows containing above names use the following query:

SELECT Y.* 
  FROM YourTable Y
  JOIN (SELECT FirstName, LastName, COUNT(*) cnt
          FROM YourTable
           GROUP BY FirstName, LastName
          HAVING COUNT(*) > 1) D 
    ON D.FirstName = Y.FirstName AND D.LastName = Y.LastName
 ORDER BY Y.FirstName, Y.LastName

Select allOpen in new window

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).

In other words, I want to show the records - and only those records - that have the FirstName identical to the LastName.

That's what I thought I tried before and got an error.
Works.  :)