暂无图片
返回数说广场
Ellison
2023-08-24 这家伙很懒, 什么也没留下~
查看表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
分享

评论

热门数说