SELECT @@IDENTITY FROM MyTable;

##</code><code>##

INSERT INTO MyTable (x,y) VALUES (1,2) RETURNING rowid;