想查詢的是借方和貸方金額的。
如果不加括號，查詢不僅慢，并且效率低。

select gl_detail.explanation,bd_accsubj.dispname,gl_detail.debitamount 借方,gl_detail.creditamount 貸方,gl_detail.prepareddatev 制單日期,gl_voucher.no 憑證號,wmsys.wm_concat(gl_freevalue.valuecode) valuecode,wmsys.wm_concat(gl_freevalue.valuename) valuenamefrom bd_accsubjjoin gl_detailon gl_detail.pk_accsubj = bd_accsubj.pk_accsubjjoin bd_glorgbookon bd_glorgbook.pk_glorgbook = bd_accsubj.pk_glorgbookjoin gl_voucheron gl_detail.pk_voucher = gl_voucher.pk_voucherleft join gl_freevalueon gl_detail.assid = gl_freevalue.freevalueidwhere gl_detail.dr = '0'and gl_detail.yearv = '2011'and bd_glorgbook.glorgbookcode = '0100-0001'and (gl_detail.debitamount='6202549' or gl_detail.creditamount='6202549') --and bd_accsubj.subjcode like '150103%'group by gl_detail.explanation,bd_accsubj.dispname,gl_detail.creditamount,gl_detail.debitamount,gl_detail.prepareddatev,gl_voucher.noorder by gl_detail.prepareddatev, gl_voucher.no

轉載于:https://www.cnblogs.com/sumsen/archive/2012/05/29/2524832.html

總結

以上是生活随笔為你收集整理的SQL的or及括号的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。