Loading

How to load the last updated value from sql server 2012

santhosh kumar

12y1.4k

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"

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jitendra Kumar12y ago
Hi Santosh,

use this.

Select sweetname , total_qty from SweetStockBalance where sweetname = "Halwa" and
date = MAX(date)
0
Anubhav Chaudhary12y ago
Hi,
I think you are not inserting the time with the date in Date column, you should insert datetime in date column and then apply max on this column, then you will get the latest value.
0