摘要:
SELECT base.* from(select id_no,COUNT(*) from aim.aim_t_cust_base GROUP BY id_no HAVING COUNT(*) >1) as t left join aim.aim_t_cust_base base on t.id_n 阅读全文
摘要:
实例1: SET @ID = 0; SELECT AVG(loan_amount) from ( SELECT @ID:=@ID+1 as ID, loan_amount FROM table_xxx ORDER BY loan_amount ) a where IF( ROUND(@ID/2,0) 阅读全文