查看表BOOKS_TRANSACTIONS的描述 Name Null? Type -------------------------------------------------- TRANSACTION_ID NOT NULL VARCHAR2(6) TRANSACTION_TYPE VARCHAR2(3) BORROWED_DATE DATE BOOK_ID ARCHAR2(6) MEMBER_ID VARCHAR2(6) 查看如下一部分SQL： SELECT * FROM books_transctions 哪两个WHERE子句会返回相同的查询结果。AC A WHERE borrowed_date = SYSDATE AND transaction_type= 'RM' OR member_id IN ('A101','A102' ) ; B WHERE borrowed_date = SYSDATE AND (transaction_type= 'RM' AND ( member_id= 'A101' OR member_id = 'A102' ) ); C WHERE (borrowed_date = SYSDATE AND transaction_type= 'RM' ) OR member_id IN ('A101','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' AND member_id='A101' OR member_id = 'A102') );