SELECT A.XFH0101, A.XFH0103, DECODE(A.XFH0104,0,'0.00',(TO_CHAR(ROUND(A.XFH0104,2),'FM99999999999999.00'))) AS XFH0104, A.XFH0109,TO_CHAR(A.XFH0112,'YYYY-MM-DD HH:MI:SS') AS XFH0112, A.CZZX1001,B.BAAX0102,C.BACX0501,TO_CHAR(A.XFH0114,'YYYY-MM-DD') AS XFH0114, XFH0120,XFH0121, DECODE( D.XFH0302, 0, '0.00', ( TO_CHAR ( ROUND( D.XFH0302, 2 ), 'fm999999990D00' ) ) ) AS XFH0302, D.XFH0304, E.XFF0103, DECODE( D.XFH0302 * D.XFH0304,0, '0.00', (TO_CHAR(ROUND( D.XFH0302 * D.XFH0304, 2 ), 'fm999999990D00' ))) AS SUM FROM XFH01 A LEFT JOIN BAA01 B ON A.CZZX1001 = B.BAAX0101 LEFT JOIN BAC05 C ON A.SYSCODE = C.SYSCODE JOIN XFH03 D ON A.XFH0101 = D.XFH0101 JOIN XFF01 E ON D.XFF0101 = E.XFF0101 WHERE A.XFH0101 in (${xfh0101})
时间: 2024-01-18 12:03:26 浏览: 34
这是一个SQL查询语句,用于从多个表中检索数据。它使用了多个表之间的连接和条件筛选。查询的结果将返回一些列,包括XFH0101、XFH0103、XFH0104、XFH0109、XFH0112、CZZX1001、BAAX0102、BACX0501、XFH0114、XFH0120、XFH0121、XFH0302、XFH0304、XFF0103和SUM。
其中XFH01表与BAA01表和BAC05表进行了左连接,XFH01表与XFH03表和XFF01表进行了内连接。查询的条件是XFH0101在给定的xfh0101参数中。
请注意,我只能解释查询的含义和结构,无法直接执行查询或提供实际的查询结果。
相关问题
iptables Mark查询
根据引用\[1\]和引用\[3\]中的内容,可以使用以下命令查询iptables的Mark规则:
```
iptables -t mangle -nL PREROUTING
```
这个命令将显示PREROUTING链中的所有规则,包括MARK规则。在输出中,可以看到每个规则的源地址、目标地址以及MARK规则的设置。例如,如果有一条规则将源地址为1.1.1.1的数据包的nfmark值设置为0x1,那么在输出中会显示类似于"MARK set 0x1"的信息。
#### 引用[.reference_title]
- *1* *3* [iptables MARK](https://blog.csdn.net/weixin_43855786/article/details/130052943)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control_2,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* [iptables中的MARK用法](https://blog.csdn.net/XFH1207/article/details/109469775)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control_2,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)