返回数说广场
0
查看表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子句会返回相同的查询结果。
A
WHERE borrowed_date = SYSDATE AND transaction_type= 'RM' OR member_id IN ('A101','A102' ) ;
C
WHERE (borrowed_date = SYSDATE AND transaction_type= 'RM' ) OR member_id IN ('A101','A102' );
0
0 225
分享
评论
热门数说


