title: How to select the last record of a table in SQL?
body: <p>This is a sample code to select all records from a table. Can someone show me how to select the last record of that table?</p>
  
  <pre><code>select * from table
  </code></pre>
  
  <p>When I use: <code>SELECT * FROM TABLE ORDER BY ID DESC LIMIT</code> 
  I get this error: Line 1: Incorrect syntax near 'LIMIT'.
  This is the code I use: </p>
  
  <pre><code>private void LastRecord()
  {
      SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["HELPDESK_OUTLOOKConnectionString3"].ToString());
  
      conn.Open();
      SqlDataReader myReader = null;
      SqlCommand myCommand = new SqlCommand("SELECT * FROM HD_AANVRAGEN ORDER BY " +
                  "aanvraag_id DESC LIMIT 1", conn);
      myReader = myCommand.ExecuteReader();
      while (myReader.Read())
      {
          TextBox1.Text = (myReader["aanvraag_id"].ToString());
          TextBox1.Text += (myReader["wijziging_nummer"].ToString());
          TextBox1.Text += (myReader["melding_id"].ToString());
          TextBox1.Text += (myReader["aanvraag_titel"].ToString());
          TextBox1.Text += (myReader["aanvraag_omschrijving"].ToString());
          TextBox1.Text += (myReader["doorlooptijd_id"].ToString());
          TextBox1.Text += (myReader["rapporteren"].ToString());
          TextBox1.Text += (myReader["werknemer_id"].ToString());
          TextBox1.Text += (myReader["outlook_id"].ToString());
      }
  }
  </code></pre>