数据库有3张表,如何查询在商品名称中包含可口可乐字样的商品店内码以及商品条形码

2025-02-27 22:28:35
推荐回答(1个)
回答1:

select item_code,barcode from item
where description like '%可口可乐%';

select sum(sales_value)salevalue,sum(sales_unit) salesl
from sales where to_char(period,'yyyymm')='200907' order by 1