How to select last inserted row by id?

Question

that my problem:

I have database table like that:

id (AI)    market_id
1             6       
2            10      
3             6       
4            10   
5            11

How to select last inserted market_id by id?

please specify database and if the ID is of type AutoIncrement — Habib, Mar 28 '12 at 07:44
Which one is the last inserted marked_id? 6, 10 or 11? How do you identify the "last"? — , Mar 28 '12 at 07:46
The last inserted marked_id I identify by id which is auto-increment — Donatas Veikutis, Mar 28 '12 at 08:21

score 3 · Accepted Answer · answered Mar 28 '12 at 07:41

3

You could do something like this:

SELECT * FROM <your_table> ORDER BY id DESC LIMIT 1;

If you only are interested in the market_id you could change the * in the above query to market_id.

answered Mar 28 '12 at 07:41

Cyclonecode

score 1 · Answer 2 · answered Mar 28 '12 at 07:43

1

You can use LAST_INSERT_ID():

SELECT market_id FROM <table> where id=LAST_INSERT_ID();

answered Mar 28 '12 at 07:43

dexametason

score 0 · Answer 3 · answered Mar 28 '12 at 07:42

0

For SQL Server,

Select TOP 1 ID, market_I'd from table order by ID desc

answered Mar 28 '12 at 07:42

Russell Hart

3 Answers3