[RESOLVED] select statement to get the all data with last sr_number save

[newphpcoder]

Hi..

I just want to know what is the code to get the last inserted row on database.

I tried max and last_insert_id yet it did not solve my problem

SELECT last_insert_id(sr_number), sr_date, Items, SubItems, ItemCode, DemandedQty FROM stock_requisition;

it display all data from my database.

SELECT max(sr_number), sr_date, Items, SubItems, ItemCode, DemandedQty FROM stock_requisition;

it only display last row.. but I need to display all data with all data with same sr_number
for example :

1204100002

I attach my sample data from my database:

Thank you so much

[chrisranjana]

SELECT sr_number, sr_date, Items, SubItems, ItemCode, DemandedQty FROM stock_requisition WHERE  sr_number = (SELECT max(sr_number) from stock_requisition)

[newphpcoder]

SELECT sr_number, sr_date, Items, SubItems, ItemCode, DemandedQty FROM stock_requisition WHERE  sr_number = (SELECT max(sr_number) from stock_requisition)

Thank you..

It resolved my problem