sql查询以从列中选择最大值 [英] sql query to select max value from a coloumn

问题描述

表:原材料费用

栏目:原材料代码，费用，id(主键)

查询:如何获取费用，其中rawmaterialcode = 1并且id为最大值

table: rawmaterialexpenses

coloumn: rawmaterialcode,expense,id(primary key)

query: how to get expense where rawmaterialcode = 1 and id is maximum

推荐答案

尝试以下操作:

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

这篇关于sql查询以从列中选择最大值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！