Compare Two Rows and Find the Difference Between Them Which is In The Second Column?
You could rephrase it like this:


  Return every row for which another row exists with the same Name and a different LastName


which is very easy to translate to SQL if you are familiar with the EXISTS predicate:

SELECT
  *
FROM
  YourTable AS t1
WHERE
  EXISTS
  (
    SELECT
      *
    FROM
      YourTable AS t2
    WHERE
      t2.Name = t1.Name
      AND t2.LastName &lt;&gt; t1.LastName
  )
;