SQL数据库如何查询到这两条记录?

发布网友发布时间：2022-04-11 07:31

共4个回答

热心网友时间：2022-04-11 09:00

select barcode,dprice,min(dpricenew) from tb where barcode='2009000009660' group by barcode,dprice
union all
select barcode,dprice,max(dpricenew) from tb where barcode='2009000014602' group by barcode,dprice

热心网友时间：2022-04-11 10:18

select barcode,dprice,dpricenew from 表
where
(barcode = '2009000009660' and dprice = '4.8000' and dpricenew = '5')
or
(barcode = '2009000014602' and dprice = '57.6000' and dpricenew = '10')

热心网友时间：2022-04-11 11:53

select * from table where barcode in ('2009000009660','2009000014602') and dprice in ('4.8000','57.6000') and dpricenew in ('5','10');

热心网友时间：2022-04-11 13:44

select barcode,dprice,dpricenew
from a where dpricenew between 5 and 10

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com