Retrieve inserted row ID in SQL

by

In MySQL:

SELECT LAST_INSERT_ID();

In SQL Server:

SELECT SCOPE_IDENTITY();

In Oracle:

SELECT SEQNAME.CURRVAL FROM DUAL;

In PostgreSQL:

SELECT lastval();

(edited: lastval is any, currval requires a named sequence)
Note: lastval() returns the latest sequence value assigned by your session, independently of what is happening in other sessions.

More Related Contents:

  1. Cannot update. Database or object is read-only. Error [closed]
  2. Insert text with single quotes in PostgreSQL
  3. How to use GROUP BY to concatenate strings in MySQL?
  4. Dynamic alternative to pivot with CASE and GROUP BY
  5. How can I list all foreign keys referencing a given table in SQL Server?
  6. How ROWNUM works in pagination query?
  7. How to update only one field using Entity Framework?
  8. Split function equivalent in T-SQL?
  9. How to find all connected subgraphs of an undirected graph
  10. Is there a workaround for ORA-01795: maximum number of expressions in a list is 1000 error?
  11. How to drop SQL default constraint without knowing its name?
  12. How do I interpret precision and scale of a number in a database?
  13. Maintaining order in MySQL “IN” query
  14. Is it possible to delete from multiple tables in the same SQL statement?
  15. SQL Error: ORA-00933: SQL command not properly ended
  16. How to return the output of stored procedure into a variable in sql server
  17. A way to extract from a DateTime value data without seconds
  18. How to select only the first rows for each unique value of a column?
  19. Hamming distance on binary strings in SQL
  20. Modify Default value in SQL Server
  21. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  22. store arabic in SQL database
  23. calculate hours based on business hours in Oracle SQL
  24. Lightweight SQL database which doesn’t require installation [closed]
  25. How do I create a table alias in MySQL
  26. How to create Daylight Savings time Start and End function in SQL Server
  27. Oracle , != , ^= operators
  28. CONCAT equivalent in MS Access
  29. How to exclude a column from SELECT query?
  30. sql server displaying missing dates

Leave a Comment