尝试以下操作:

Try this:

SELECT MAX(id), expense FROM rawmaterialexpenses WHERE rawmaterialcode = 1 GROUP BY ID, expense

试试这个查询.您可以使用子查询

Hi,
Try this query. you can use sub query

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