Can I retrieve the last insert id in monetdb?

Question

I have been querying for the most recent (auto incrementing) ID of a given table I've inserted into (SELECT "id" FROM "my_table" ORDER BY "id" DESC LIMIT 1), but I'm wondering if there exists a more general way to do this, instead.

Which client are you using? JDBC? – Hannes Mühleisen May 19 '16 at 08:36 — Hannes Mühleisen, May 19 '16 at 08:36

score 0 · Accepted Answer · answered Apr 29 '16 at 06:17

0

Get Column

SELECT max ("id") FROM "my_table"

Get Row

Select * from "my table" where "id" in (SELECT max ("id") FROM "my_table")

answered Apr 29 '16 at 06:17

Alper Şaldırak

1,034
8
10

Can I retrieve the last insert id in monetdb?

1 Answers1