SQL怎么接多个查询条件

来源：百度知道 编辑：UC知道 时间：2024/07/01 14:30:47
表名sd001
查询sd0101 = 20090801 这天每个收款员SD0107的 sd0102 = 00191123,00191124这2个商品的数量，显示出4个字段SD0101,SD0102,SD0104，SD0107
REATE TABLE SD001 /*销售明细*/
(
SD0101 VARCHAR2(8) NOT NULL, /*销售日期*/
SD0102 VARCHAR2(20) NOT NULL, /*商品/柜组编码*/
SD0103 NUMBER(15,2) NOT NULL, /*商品单价*/
SD0104 NUMBER(15,2) NOT NULL, /*销售数量*/
SD0105 NUMBER(15,2) NOT NULL, /*实际售价*/
SD0106 NUMBER(15,0) NOT NULL, /*交易单号*/
SD0107 VARCHAR2(10) NOT NULL, /*收款员*/
SELECT SD0101,sd0107, SD0102, DG0102, Count(SD0102)
FROM dg001,sd001
WHERE SD0101 Like '20090801' AND SD0102='00191124' And SD0102=dg0101
GROUP BY SD0101,sd0107, SD0102, DG0102

解决了

select sd0101,sd0102,sd0104,sd0107 from sd001 where sd0101 = '20090801' and sd0102 in ('00191123','00191124');

00191123,00191124这2个商品的数量 是要分开统计还是一起统计？

select SD0101
,0102
,0104
,0107
from sd001
where SD0101=CAST('20090801' AS DATE FROMAT 'YYYYMMDD')
AND
sd0102 IN('00191123','00191124')
GROUP BY 4, 2