how can fetch last record from the database

Hi Sumit,

This is depend on your database type.

If you have a primary ke in your table with auto increment then use below query.

Select * From tableName Where PK = (Select Max(PK) From tableName)

If you are using MySql then use below query.

SELECT * FROM tableName WHERE id = LAST_INSERT_ID( );

If you are using ORALCE then use below query.

SELECT * FROM tableName where ROWID = (SELECT MAX(ROWID) FROM tableName);

Hope this will help you.

Hello Sumit,

you have to use

SELECT SCOPE_IDENTITY() in sql server

SCOPE_IDENTITY returns the last inserted IDENTITY value in this current scope.

select * from table where id=(select Max(id) from table)


//if you have primary key with auto increment

select * from table where pk=(select Max(pk) from table)

SELECT *
FROM    TABLE
WHERE   ID = (SELECT MAX(ID)  FROM TABLE)