title: SQL - Assign Unique ID for DISTINCT records
body: <p>I need to create at temp table that has two columns: language_id (number) and language (text). I have a customer table that contains my language column. I need to populate my temp table with distinct records from my language column and I need to be able to assign a language_id for each distinct language record. </p>
  
  <p>I am using '<code>SELECT DISTINCT Language from CustomerData</code>' to get distinct records, but I am not certain how to assign a language_id for each distinct record.</p>
  
  <p>My desired output is below</p>
  
  <pre><code>Language ID     Language
  1               English
  2               French
  3               Spanish
  </code></pre>
  
  <p>Any help would be much appreciated. Thank you</p>