select rateperkg from K_FS_FeedMrpDetails where date = getdate()-1
select rateperkg from (select rateperkg , ROW_NUMBER() over ( order by [date] desc ) as slno from K_FS_FeedMrpDetails ) as temp where slno = 2
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)