小编典典

如何在 SQL 中选择表的最后一条记录?

all

这是从表中选择所有记录的示例代码。有人可以告诉我如何选择该表的最后一条记录吗?

select * from table

当我使用时:SELECT * FROM TABLE ORDER BY ID DESC LIMIT 我收到此错误:第 1 行:’LIMIT’
附近的语法不正确。这是我使用的代码:

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());
    }
}

阅读 95

收藏
2022-07-18

共1个答案

小编典典

没有任何进一步的信息,我们能做的最好的数据库等是

Sql 服务器

SELECT TOP 1 * FROM Table ORDER BY ID DESC

mysql

SELECT * FROM Table ORDER BY ID DESC LIMIT 1
2022-07-18