title: SQL Server FIRST function via JDBC
body: <p>I am building an application in cold fusion which has a SQL Server database connection. I need group records and only return the first in the group. I wrote the following query in coldfusion.</p>
  
  <pre><code>SELECT FIRST(ID)
  FROM table
  GROUP BY NAME
  </code></pre>
  
  <p>Which is returning the following error:</p>
  
  <p>[Macromedia][SQLServer JDBC Driver][SQLServer]'first' is not a recognized built-in function name.</p>
  
  <p><em><strong>Is the a way use the first function in a coldfusion query?</em></strong><br></p>
  
  <p><em><strong>Is there an alternative way to accomplishment this?</em></strong></p>
  
  <p>*I do not have direct access to the database. Just a access to the cold fusion data connection</p>