How to make a DISTINCT CONCAT statement?
<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>