当前位置:百科知识 > 计算机题库

问题描述:

[单选] 现有数据库表t_order,主键为Forder_id,并在表的Fuin、Fstate、Fcreate、ime建立复合索引,下列选项中能使索引的是()。
A.selectFmerchant_id,FuinFROMt_orderWHEREForder_id=‘27000022016041412037866’; B.selectFmerchant_id,Forder_idFROMt_orderWHEREFuin=’42176034’ANDFstate=1; C.selectFmerchant_id,Fuin,FstateFROMt_orderWHEREForder_idLIKE‘%20160414%’; D.selectFmerchant_id,FamountFROMt_orderWHEREForder_id=’27000022016041412037866’ORFuin=’42176034’;
参考答案:查看
答案解析:

随机题目