我有如下查询:
SELECT r.RiderName,
bm.BranchName,
oa.AddedOn AS OrderDate,
ra.CheckIn,
ra.CheckOut,
COUNT(om.OrderId) TotalOrder,
SUM(om.OrderAmount) AS TotalAmount,
om.OrderId
FROM RiderAttendance ra
INNER JOIN Riders r ON r.RiderId = ra.RiderId
INNER JOIN BranchMaster bm ON bm.BranchId = ra.BranchId
INNER JOIN OrderAssign oa ON oa.RiderId = ra.RiderId
INNER JOIN OrderDetail od ON od.OrderId = oa.OrderId
INNER JOIN OrderMaster om ON od.OrderId = om.OrderId
WHERE od.OrderId != 0
AND bm.BranchId = 82
AND oa.AddedOn >= '05/29/2018'
AND oa.AddedOn <= '05/31/2018'
GROUP BY r.RiderName,
bm.BranchName,
oa.AddedOn,
ra.CheckIn,
ra.CheckOut,
om.OrderId
获取结果,如
。
上面可以看到,sic_name_txt =‘公司债券’有两个可能的百分比值'pgperc1‘和'pgperc',有两个不同的sic_srcid_txt 'SARA’和'Default‘。
我希望选择包含‘公司债券’‘百分比’'pgperc1‘的行,而不是其他行
发布于 2018-05-31 16:22:45
将这段代码添加到代码的末尾:
and sic_name_txt='CORPORATE BONDS'
and chd_column_header_txt='Percentage'
and chd_column_header_text_txt='pgperc1'
https://stackoverflow.com/questions/50619725
复制相似问题