经典指数          
原因
2475
浏览数
0
收藏数
 

现有数据库表t_order,主键为Forder_id,并在表的Fuin、Fstate、Fcreate、ime建立复合索引,下列选项中能使索引的是(    )
  • select Fmerchant_id,Fuin FROM t_order WHERE Forder_id=’27000022016041412037866’;
  • select Fmerchant_id,Forder_id FROM t_order WHERE Fuin=’42176034’ AND Fstate=1;
  • select Fmerchant_id,Fuin,Fstate FROM t_order WHERE Forder_id LIKE ‘%20160414%’;
  • select Fmerchant_id,Famount FROM t_order WHERE Forder_id=’27000022016041412037866’ OR Fuin=’42176034’;

     举报   纠错  
 
切换
暂时还没有答案,欢迎分享你的解答 . . .
撰写答案
扫描后移动端查看本题