How to load the last updated value from sql server 2012

Question

HI,

 this is my table in this i want the last insert sweetname and its total_qty to be displayed .i  hve written a query but i can oly get the particular sweet. the qury which i hve used is given below.

 

Select sweetname , total_qty from SweetStockBalance where sweetname = "Halwa" and date = (SELECT MAX(date) FROM SweetStockBalance where sweetname = "Halwa"