Hi....
i am having a table in which 2 values are being stored
month total
jan 2014 2000
jan 2014 30000
jan 2014 50000
feb 2014 20000
feb 2014 50000
mar 2014 20000
mar 2014 40000
i want to extract particular month total from the table but the last total of particular month how can i extract?
plz help me......
U Can do in Only Way. Add field ID As Auto Increment
Table Structure Like This
ID int Unchecked Month varchar(50) Checked Total varchar(50) Checked
query
SELECT TOP 1 Total FROM Test4 where MONTH='Jan 2014' ORDER BY ID DESC;
© COPYRIGHT 2025 ASPSnippets.com ALL RIGHTS RESERVED.