Horje
sql get last inserted row Code Example
how to get last row of table in sql 
mysql> select *from getLastRecord ORDER BY id DESC LIMIT 1;
Source: www.tutorialspoint.com
sql select last id 
#Where the the column name is "ID" and table name is "tablename" and ID naming is increasing numerical value.
SELECT * 
FROM tablename
WHERE ID = (
    SELECT MAX(ID) 
  	FROM Table)
sql get last inserted row 
select * from table where ID = (SELECT @@IDENTITY)



Sql

Related
how we can perform acid Operations in sql with examples Code Example how we can perform acid Operations in sql with examples Code Example
NOT LIKE sql laravel Code Example NOT LIKE sql laravel Code Example
delete role postgres Code Example delete role postgres Code Example
sql String comparisons case sensitive Code Example sql String comparisons case sensitive Code Example
postgres inner join vs join Code Example postgres inner join vs join Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje