Which two WHERE conditions give the same result?

【多选题】
A WHERE borrowed_date = SYSDATE AND (transaction_type= ‘RM’ AND (member_id =‘A101’ or member_id =‘A102’))
B WHERE borrowed_date = SYSDATE AND (transaction_type= ‘RM’ or member_id in(‘A101’ ,‘A102’))
C WHERE borrowed_date = SYSDATE AND (transaction_type= ‘RM’ AND member_id =‘A101’ or member_id =‘A102’)
D WHERE borrowed_date = SYSDATE AND transaction_type= ‘RM’ or member_id in(‘A101’ ,‘A102’)
E WHERE (borrowed_date = SYSDATE AND transaction_type= ‘RM’ )or member_id in(‘A101’ ,‘A102’)

查看更多