How to select the last record of a table in SQL

Question

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   select   from table   When I use  SELECT   FROM TABLE ORDER BY ID DESC LIMIT  I get this error  Line 1  Incorrect syntax near  LIMIT   This is the code I use    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

User · Answer

to get the last row of a SQL-Database use this sql string   SELECT   FROM TableName WHERE id  SELECT max id  FROM TableName     Output   Last Line of your db

User · Answer

Without any further information  which Database etc the best we can do is something like  Sql Server  SELECT TOP 1   FROM Table ORDER BY ID DESC   MySql  SELECT   FROM Table ORDER BY ID DESC LIMIT 1

User · Answer

MS SQL Server has supported ANSI SQL FETCH FIRST for many years now  SELECT   FROM TABLE ORDER BY ID DESC  OFFSET 0 ROWS FETCH FIRST 1 ROW ONLY   Works with most modern databases

User · Answer

I think this should do it    declare  x int  select  x   max id  from table name  select   from where id    x

User · Answer

In Oracle  you can do   SELECT   FROM  SELECT EMP   ROWNUM FROM EMP ORDER BY ROWNUM DESC  WHERE ROWNUM 1    This is one of the possible ways

User · Answer

Almost all answers assume the ID column is ordered  and perhaps auto incremented   There are situations  however  when the ID column is not ordered  hence the ORDER BY statement makes no sense  The last inserted ID might not always be the highest ID  it is just the last  unique  entry  One possible solution for such a situation is to create a row id on the fly  SET  r   0  SELECT   FROM  SELECT      r     r   1  AS r id FROM uat3187  AS tmp     ORDER BY r id DESC LIMIT 1

User · Answer

sql  SELECT tot visit FROM visitors WHERE date   DATE NOW    - 1 into  s                  conn- gt query  sql    sql    INSERT INTO visitors  nbvisit day date tot visit  VALUES  1 CURRENT DATE  s 1     conn- gt query  sql

User · Answer

SELECT   FROM TABLE ORDER BY ID DESC LIMIT 1   Yes this is mysql  SQL Server   SELECT TOP 1   FROM Table ORDER BY ID DESC

User · Answer

You can also do something like this    SELECT LAST  column name  AS LAST CUSTOMER FROM table name

User · Answer

It is always a good practice in your table design to have an automatic row identifier  such as    RowID   int  IDENTITY 1 1  NOT FOR REPLICATION NOT NULL     then you can identify your last row by    select   from yourTable where rowID      IDENTITY

User · Answer

If you have a self-incrementing field  say ID  then you can do something like  SELECT   FROM foo WHERE ID    SELECT max ID  FROM foo

User · Answer

I upvoted Ricardo  Actually max is much efficient than sorting    See the differences  its excellent    I had to get the last row update record  timeStamp     sqlite gt  select timeStamp from mypadatav2 order by timeStamp desc limit 1   2020-03-11 23 55 00  Run Time  real 1 806 user 1 689242 sys 0 117062    sqlite gt  select max timeStamp  from mypadatav2   2020-03-11 23 55 00  Run Time  real 0 553 user 0 412618 sys 0 134340

User · Answer

The last is just the first when you reverse your ordering

User · Answer

Assuming you have an Id column   SELECT TOP 1     FROM table  ORDER     BY Id DESC    Also  this will work on SQL Server   I think that MySQL you might need to use   SELECT     FROM table  ORDER     BY Id DESC  LIMIT 1   But  I m not 100  sure about this   EDIT  Looking at the other answers  I m now 100  confident that I m correct with the MySQL statement  o   EDIT  Just seen your latest comment   You could do   SELECT MAX Id    FROM table   This will get you the highest Id number

User · Answer

select ADU itemid  ADU startdate  internalcostprice  from ADUITEMINTERNALCOSTPRICE ADU  right join      select max STARTDATE  as Max date  itemid     from ADUITEMINTERNALCOSTPRICE    group by itemid  as A  on A ITEMID   ADU ITEMID and startdate  Max date

User · Answer

SELECT   FROM table ORDER BY Id DESC LIMIT 1

[sql] How to select the last record of a table in SQL?

Examples related to sql

Examples related to sql-server

Examples related to sql-server-2008