试题详情

SQL语句, 以下语句会导致全表扫描的是____

Aselect id from t where substring(name,1,3) =‘abc‘

Bselect id from t where name like ‘cif%‘

Cselect id from table_1 where num=10

Dselect id from t where createdate>=‘2005- 11-30‘ and createdate