delta_txz = delta_tx**2+delta_tz**2
时间: 2024-06-18 18:04:30 浏览: 15
这个式子可以看作是勾股定理的变形,其中delta_tx和delta_tz代表直角三角形的两条直角边的长度,而delta_txz代表斜边的长度。因此可以将delta_tx和delta_tz看作是已知量,然后通过这个式子来计算出斜边的长度。
在python中,我们可以很容易地用这个式子来计算斜边的长度,例如:
```python
delta_tx = 3
delta_tz = 4
delta_txz = delta_tx**2 + delta_tz**2
print("delta_txz is: ", delta_txz) # 输出:25
```
这里我们假设delta_tx的长度是3,delta_tz的长度是4,然后通过这个式子计算出delta_txz的长度为5。因此我们可以得到delta_txz等于25。
相关问题
请帮我看看这个sql语句是否正确,并改正:select a.ebeln, a.ebelp, a.art, a.kdauf, a.zbw, a.size1, a.txz01, a.menge, b.quantity, (a.menge - b.quantity) as OWE_MATERIAL, ( select sum(THIS_PLAN_QTY) as HAVE_PLAN , a.ebeln , a.ebelp , a.kdauf from SCM_OUTSOURCE_PRODUCTION_PLAN_LIST c , SCM_PROCESS_PURCHASE_ORDER_D a group by c.order_no , c.order_seq , c.sales_order , a.ebeln , a.ebelp , a.kdauf having c.order_no = a.ebeln And c.order_seq = a.ebelp And c.sales_order = a.kdauf ) , ( select a.menge - t.HAVE_PLAN as OWN_PLAY from (select sum(THIS_PLAN_QTY) as HAVE_PLAN , c.order_no , c.order_seq , c.sales_order from SCM_OUTSOURCE_PRODUCTION_PLAN_LIST c , SCM_PROCESS_PURCHASE_ORDER_D a group by c.order_no , c.order_seq , c.sales_order , a.ebeln , a.ebelp , a.kdauf having c.order_no = a.ebeln And c.order_seq = a.ebelp And c.sales_order = a.kdauf ) t , SCM_PROCESS_PURCHASE_ORDER_D a where a.ebeln = t.order_no and a.ebelp = t.order_seq and a.menge = t.sales_order ) , d.scan_qty, (d.quantity - d.scan_qty) as OWN_PRODUCE, e.scan_qty, (e.quantity - e.scan_qty) as OWE_SHIP from SCM_PROCESS_PURCHASE_ORDER_D a left join MMS_INOUT_BILL_M b On a.ebeln = b.purchase_order_number And a.ebelp = b.purchase_order_seq And a.kdauf = b.sales_order left join SCM_OUTSOURCE_PRODUCTION_PLAN_LIST c on a.ebeln = c.order_no And a.ebelp = c.order_seq And a.kdauf = c.sales_order left join SCM_PROCESS_OUTPUT d on a.ebeln = d.order_no And a.ebelp = d.order_seq And a.kdauf = d.sales_order left join SCM_OUTSOURCE_SHIP e on a.ebeln = e.qr_code and a.ebelp = e.order_no and a.kdauf = e.order_seq where a.art = 'IE7181' Order by a.ebeln desc, a.ebelp;
这个 SQL 语句比较复杂,但是有一些问题需要修改:
- 在子查询中,需要将 select 子句中的 a.ebeln, a.ebelp, a.kdauf 与 group by 子句中的字段保持一致,否则会出现错误。
- 子查询中的第一个 SELECT 子句需要加上 WHERE 子句,限制查询条件。
- 子查询中的第二个 SELECT 子句中的 a.menge 应该改为 t.sales_order。
- 在最后的 SELECT 子句中,d.scan_qty 与 e.scan_qty 都没有明确指定表名,可能会出现错误。
以下是修改后的 SQL 语句:
```
SELECT
a.ebeln,
a.ebelp,
a.art,
a.kdauf,
a.zbw,
a.size1,
a.txz01,
a.menge,
b.quantity,
(a.menge - b.quantity) AS OWE_MATERIAL,
(
SELECT
SUM(c.THIS_PLAN_QTY) AS HAVE_PLAN,
a.ebeln,
a.ebelp,
a.kdauf
FROM
SCM_OUTSOURCE_PRODUCTION_PLAN_LIST c,
SCM_PROCESS_PURCHASE_ORDER_D a
WHERE
c.order_no = a.ebeln
AND c.order_seq = a.ebelp
AND c.sales_order = a.kdauf
AND a.art = 'IE7181'
GROUP BY
c.order_no,
c.order_seq,
c.sales_order,
a.ebeln,
a.ebelp,
a.kdauf
),
(
SELECT
a.menge - t.sales_order AS OWN_PLAY
FROM
(
SELECT
SUM(c.THIS_PLAN_QTY) AS HAVE_PLAN,
c.order_no,
c.order_seq,
c.sales_order
FROM
SCM_OUTSOURCE_PRODUCTION_PLAN_LIST c,
SCM_PROCESS_PURCHASE_ORDER_D a
WHERE
c.order_no = a.ebeln
AND c.order_seq = a.ebelp
AND c.sales_order = a.kdauf
AND a.art = 'IE7181'
GROUP BY
c.order_no,
c.order_seq,
c.sales_order,
a.ebeln,
a.ebelp,
a.kdauf
) t,
SCM_PROCESS_PURCHASE_ORDER_D a
WHERE
a.ebeln = t.order_no
AND a.ebelp = t.order_seq
AND a.kdauf = t.sales_order
AND a.art = 'IE7181'
),
d.scan_qty,
(d.quantity - d.scan_qty) AS OWN_PRODUCE,
e.scan_qty,
(e.quantity - e.scan_qty) AS OWE_SHIP
FROM
SCM_PROCESS_PURCHASE_ORDER_D a
LEFT JOIN MMS_INOUT_BILL_M b ON a.ebeln = b.purchase_order_number AND a.ebelp = b.purchase_order_seq AND a.kdauf = b.sales_order
LEFT JOIN SCM_OUTSOURCE_PRODUCTION_PLAN_LIST c ON a.ebeln = c.order_no AND a.ebelp = c.order_seq AND a.kdauf = c.sales_order
LEFT JOIN SCM_PROCESS_OUTPUT d ON a.ebeln = d.order_no AND a.ebelp = d.order_seq AND a.kdauf = d.sales_order
LEFT JOIN SCM_OUTSOURCE_SHIP e ON a.ebeln = e.qr_code AND a.ebelp = e.order_no AND a.kdauf = e.order_seq
WHERE
a.art = 'IE7181'
ORDER BY
a.ebeln DESC,
a.ebelp;
```
long fail = jdcs.stream().filter(one -> one.getZt() == YwConstants.TXZ_SQ_ZT_SHJJ).count();
这是一段 Java 8 Lambda 表达式的代码,它使用 Stream API 对 jdcs 集合中元素进行筛选,并统计满足条件的元素个数。具体来说,这段代码的功能是统计 jdcs 集合中状态为 YwConstants.TXZ_SQ_ZT_SHJJ 的元素个数,并将结果赋值给 fail 变量。其中,箭头函数 one -> one.getZt() == YwConstants.TXZ_SQ_ZT_SHJJ 表示对 jdcs 集合中的每个元素进行判断,返回 true 的元素会被计入统计。count() 方法则是用于统计满足条件的元素个数。
相关推荐
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)