Question

怎么用SQL语句查询一件物品的最高价和最低价

最好详细点写下语法~~！在此先谢上~~~！
字段名如图，表名为items_ordered

Answer 1

最高价：
select * from items_ordered where price = (select max(price) from items_ordered )

1.select max(price) from items_ordered的意思是找出最高价，
2。然后在items_ordered 中查找，哪条记录的价钱符合第1条的要求，也就是说，那条记录的价钱是最高的。

最低价同理：

最低价：
select * from items_ordered where price = (select min(price) from items_ordered )

Answer 2

update x
set x1=(select sum(1) from a where right(x,1)=1),
x2=(select sum(1) from a where right(x,1)=2),
x3=(select sum(1) from a where right(x,1)=3),
x4=(select sum(1) from a where right(x,1)=4),
x5=(select sum(1) from a where right(x,1)=5)

如果对您有帮助，请记得采纳为满意答案，谢谢！祝您生活愉快！

vaela

Answer 3

select item,max(price/quantity) as 最高价,min(price/quantity) as 最低价 from items_ordered group by item;

Answer 4

SELECT
Item,
MAX(price) AS 最高价,
MIN(price) AS 最低价
FROM
items_ordered
GROUP BY
Item

Answer 5

select Item,max(price) from items_ordered group by Item

select Item,min(price) from items_ordered group by Item