How to select last row inserted

Question

I inserted values into an SQL table that has an auto increment primary key and I want to get the Pk value that the last insert has it. How do I do that?

Are you using SQL Server or MYSQL? – Aamir Jan 01 '18 at 09:23 — Aamir, Jan 01 '18 at 09:23
use MAX(columnname) in your sql query... – Mohammad Jan 01 '18 at 09:24 — Mohammad, Jan 01 '18 at 09:24
You can order by the key with DESC and take the first row – LucaP Jan 01 '18 at 09:26 — LucaP, Jan 01 '18 at 09:26

score 0 · Answer 1 · answered Jan 01 '18 at 09:26

0

try this

@LastInsertedId=SCOPE_IDENTITY()

you should use this after insert query

insert into table(ColumnName)values("name")
@LastInsertedId=SCOPE_IDENTITY()

answered Jan 01 '18 at 09:26

ali zarei

1,212
11
17

score 0 · Answer 2 · answered Jan 01 '18 at 10:15

0

if you want to get the PK when you insert values you can use this code:

INSERT INTO table_name (column2,column3,column4)
OUTPUT Inserterd.column1
VALUES (value1,value2,value3)

in above code column1 is the PK that is auto increment you want to get.

answered Jan 01 '18 at 10:15

mohamadkamal

43
6

score 0 · Answer 3 · edited Jan 01 '18 at 12:20

0

I think it would be easier if you first add a column in your named Updatedate (datetime), then you can just write the query like below :

Select top 1 * 
From TableName 
Order By Updatedate desc

edited Jan 01 '18 at 12:20

marc_s

732,580
175
1,330
1,459

answered Jan 01 '18 at 11:10

Phoenix

1
1

1

This is **NOT** going to work in a system with even just medium load of concurrent users - by the time your code gets to the point to select the `TOP 1` row, one or several **more** rows could have been inserted by other users of the system. This is **NOT RELIABLE** and thus **NOT RECOMMENDED!** – marc_s Jan 01 '18 at 12:20

How to select last row inserted

3 Answers3