SELECT MAX(id), expense FROM rawmaterialexpenses WHERE rawmaterialcode = 1 GROUP BY ID, expense
SELECT expense FROM rawmaterialexpenses WHERE rawmaterialcode = 1 AND id = (SELECT MAX(id) FROM rawmaterialexpenses)
select expense from rawmaterialexpenses where id =(select max(id) from rawmaterialexpenses ) AND rawmaterialcode = 1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)