3 Replies Latest reply on Jan 7, 2007 12:07 AM by BKBK

    where max

    RyanG24 Level 1
      Hi i need a query which selects only the max ID, I tried below but get an error any ideas?

      <cfquery name="GetNew" datasource="#application.ds#">
      SELECT *
      FROM SMS_Players_Table
      WHERE PlayerID = MAX(PlayerID)
      </cfquery>