title: Get doubles with combination and group by
body: <p>I create test table:</p>
  
  <pre><code>CREATE TABLE #TempTable(
  LoginName varchar(500),
  FullName varchar(500),
  mobilephone varchar(500))
  </code></pre>
  
  <p>Fill in the table:</p>
  
  <pre><code>insert into #TempTable
  select 'guid1', 'FullName1', 'mobilephone1'
  union select 'guid2', 'FullName1', 'mobilephone1'
  union select 'guid3', 'FullName2', 'mobilephone2'
  union select 'guid4', '------', 'mobilephone2'
  union select 'guid5', 'FullName3', 'mobilephone3'
  union select 'guid6', 'FullName3', 'mobilephone3'
  union select 'guid7', 'FullName4', 'mobilephone4'
  union select 'guid8', '------', 'mobilephone4'
  </code></pre>
  
  <p>I need select doubles by mobilephone where first FullName is valid and second FullName = '------'
  Thanks</p>