title: How to make a DISTINCT CONCAT statement?
body: <p>New SQL developer here, how do I make a <code>DISTINCT</code> <code>CONCAT</code> statement?</p>
  
  <p>Here is my statement without the <code>DISTINCT</code> key:</p>
  
  <pre><code>COLUMN Employee FORMAT a25;
  SELECT CONCAT(CONCAT(EMPLOYEEFNAME, ' '), EMPLOYEELNAME) AS "Employee", JOBTITLE "Job Title" 
  FROM Employee
  ORDER BY EMPLOYEEFNAME;
  </code></pre>
  
  <p>Here is it's output:</p>
  
  <pre><code>Employee                  Job Title               
  ------------------------- -------------------------
  Bill Murray               Cable Installer          
  Bill Murray               Cable Installer          
  Bob Smith                 Project Manager          
  Bob Smith                 Project Manager          
  Frank Herbert             Network Specilist        
  Henry Jones               Technical Support        
  Homer Simpson             Programmer               
  Jane Doe                  Programmer               
  Jane Doe                  Programmer               
  Jane Doe                  Programmer               
  Jane Fonda                Project Manager          
  John Jameson              Cable Installer          
  John Jameson              Cable Installer          
  John Carpenter            Technical Support        
  John Carpenter            Technical Support        
  John Jameson              Cable Installer          
  John Carpenter            Technical Support        
  John Carpenter            Technical Support        
  Kathy Smith               Network Specilist        
  Mary Jane                 Project Manager          
  Mary Jane                 Project Manager          
  
   21 rows selected 
  </code></pre>
  
  <p>If I were to use the <code>DISTINCT</code> key I should only have 11 rows selected, however
  if I use <code>SELECT DISTINCT CONCAT</code> I get an error.</p>