select au_id from authors where state=”ca” or state=”ks”.下面哪一條語句與這一條語句執(zhí)行效果相同()
A. select au_id from authors where state IN(“ac”,:”sk”);
B. select au_id from authors where state between ac and sk
C. select au_id from authors where state not between ca and ks
D. select au_id from authors where state IN(“ca”,:”ks”);