我需要在SQL的where子句中编写if条件,以便定义如果一列为null,则在一行中搜索另一列。我已经使用了联合,但它使查询执行缓慢,所以请帮助我以正确的方式编写这条语句。这是我现在拥有的代码: SELECT * WHERE (IF ACCOUNTID IS NULL THEN REF_ACC_ID = 12 ELSE ACCOUNTID =
如何使用criteriaquery转换sql查询mysql查询此代码: SELECT a.customer as customer, a.cbgroup, a.cbdept, a.buc, a.customer_groupa.cbdept, a.buc, a.customer_group, a.product, a.valuta, SUM(a.amount) as a_amount FROM summaryfee as a WHEREINNER JOIN SELECT b.customer, SUM